package com.ourteam.system.dao;

import net.dao.BaseQueryBean;
import net.dao.BaseWhereCriterion;
import net.dao.IDataAccessInterface;

import org.apache.commons.lang.StringUtils;

import java.util.Arrays;
import java.util.List;
import java.util.Map;


/**
 * Template Name : DAO查询对象
 * Template Version : 1
 * Template Last Modfiy Date : Sat Aug 19 10:06:32 CST 2017
 * Auto Generate Date : 2018-07-31 15:13:26
  * Warning ! This file will be overwrite when regenerate !
  *
 */
public class SysRoleDAOQueryBean extends BaseQueryBean {
    public SysRoleDAOQueryBean() {
        super();
    }

    public SysRoleDAOQueryBean(BaseQueryBean aQueryBean) {
        super(aQueryBean);
    }

    public SysRoleDAOQueryBean(BaseQueryBean aQueryBean, Map tableReplaceMap) {
        super(aQueryBean, tableReplaceMap);
    }

    public Criteria createCriteria() {
        Criteria criteria = createCriteriaInternal();

        if (oredCriteria.size() == 0) {
            oredCriteria.add(criteria);
        }

        return criteria;
    }

    protected Criteria createCriteriaInternal() {
        return new Criteria(this);
    }

    public void addIdSelectProperty() {
        addIdSelectProperty("id");
    }

    public void addIdSelectProperty(String aAlias) {
        if (StringUtils.isNotBlank(aAlias)) {
            addSelectProperty(ISysRoleDAO.Id, aAlias);
        } else {
            addSelectProperty(ISysRoleDAO.Id, "id");
        }
    }

    public void addDomainIdSelectProperty() {
        addDomainIdSelectProperty("domainId");
    }

    public void addDomainIdSelectProperty(String aAlias) {
        if (StringUtils.isNotBlank(aAlias)) {
            addSelectProperty(ISysRoleDAO.DomainId, aAlias);
        } else {
            addSelectProperty(ISysRoleDAO.DomainId, "domainId");
        }
    }

    public void addRemarksSelectProperty() {
        addRemarksSelectProperty("remarks");
    }

    public void addRemarksSelectProperty(String aAlias) {
        if (StringUtils.isNotBlank(aAlias)) {
            addSelectProperty(ISysRoleDAO.Remarks, aAlias);
        } else {
            addSelectProperty(ISysRoleDAO.Remarks, "remarks");
        }
    }

    public void addRoleCodeSelectProperty() {
        addRoleCodeSelectProperty("roleCode");
    }

    public void addRoleCodeSelectProperty(String aAlias) {
        if (StringUtils.isNotBlank(aAlias)) {
            addSelectProperty(ISysRoleDAO.RoleCode, aAlias);
        } else {
            addSelectProperty(ISysRoleDAO.RoleCode, "roleCode");
        }
    }

    public void addRoleNameSelectProperty() {
        addRoleNameSelectProperty("roleName");
    }

    public void addRoleNameSelectProperty(String aAlias) {
        if (StringUtils.isNotBlank(aAlias)) {
            addSelectProperty(ISysRoleDAO.RoleName, aAlias);
        } else {
            addSelectProperty(ISysRoleDAO.RoleName, "roleName");
        }
    }

    public void addRoleTypeSelectProperty() {
        addRoleTypeSelectProperty("roleType");
    }

    public void addRoleTypeSelectProperty(String aAlias) {
        if (StringUtils.isNotBlank(aAlias)) {
            addSelectProperty(ISysRoleDAO.RoleType, aAlias);
        } else {
            addSelectProperty(ISysRoleDAO.RoleType, "roleType");
        }
    }

    public void addStatusSelectProperty() {
        addStatusSelectProperty("status");
    }

    public void addStatusSelectProperty(String aAlias) {
        if (StringUtils.isNotBlank(aAlias)) {
            addSelectProperty(ISysRoleDAO.Status, aAlias);
        } else {
            addSelectProperty(ISysRoleDAO.Status, "status");
        }
    }

    public void addDefaultFlagSelectProperty() {
        addDefaultFlagSelectProperty("defaultFlag");
    }

    public void addDefaultFlagSelectProperty(String aAlias) {
        if (StringUtils.isNotBlank(aAlias)) {
            addSelectProperty(ISysRoleDAO.DefaultFlag, aAlias);
        } else {
            addSelectProperty(ISysRoleDAO.DefaultFlag, "defaultFlag");
        }
    }

    public void addModifyTimeSelectProperty() {
        addModifyTimeSelectProperty("modifyTime");
    }

    public void addModifyTimeSelectProperty(String aAlias) {
        if (StringUtils.isNotBlank(aAlias)) {
            addSelectProperty(ISysRoleDAO.ModifyTime, aAlias);
        } else {
            addSelectProperty(ISysRoleDAO.ModifyTime, "modifyTime");
        }
    }

    public void addOperatorIdSelectProperty() {
        addOperatorIdSelectProperty("operatorId");
    }

    public void addOperatorIdSelectProperty(String aAlias) {
        if (StringUtils.isNotBlank(aAlias)) {
            addSelectProperty(ISysRoleDAO.OperatorId, aAlias);
        } else {
            addSelectProperty(ISysRoleDAO.OperatorId, "operatorId");
        }
    }

    public void addOperatorNameSelectProperty() {
        addOperatorNameSelectProperty("operatorName");
    }

    public void addOperatorNameSelectProperty(String aAlias) {
        if (StringUtils.isNotBlank(aAlias)) {
            addSelectProperty(ISysRoleDAO.OperatorName, aAlias);
        } else {
            addSelectProperty(ISysRoleDAO.OperatorName, "operatorName");
        }
    }

    public void addDomainTitleKeySelectProperty() {
        addDomainTitleKeySelectProperty("domainTitleKey");
    }

    public void addDomainTitleKeySelectProperty(String aAlias) {
        if (StringUtils.isNotBlank(aAlias)) {
            addSelectProperty(ISysRoleDAO.DomainTitleKey, aAlias);
        } else {
            addSelectProperty(ISysRoleDAO.DomainTitleKey, "domainTitleKey");
        }
    }

    public void addDomainNameSelectProperty() {
        addDomainNameSelectProperty("domainName");
    }

    public void addDomainNameSelectProperty(String aAlias) {
        if (StringUtils.isNotBlank(aAlias)) {
            addSelectProperty(ISysRoleDAO.DomainName, aAlias);
        } else {
            addSelectProperty(ISysRoleDAO.DomainName, "domainName");
        }
    }

    public void addDomainCodeSelectProperty() {
        addDomainCodeSelectProperty("domainCode");
    }

    public void addDomainCodeSelectProperty(String aAlias) {
        if (StringUtils.isNotBlank(aAlias)) {
            addSelectProperty(ISysRoleDAO.DomainCode, aAlias);
        } else {
            addSelectProperty(ISysRoleDAO.DomainCode, "domainCode");
        }
    }

    public void addDomainSortIndexSelectProperty() {
        addDomainSortIndexSelectProperty("domainSortIndex");
    }

    public void addDomainSortIndexSelectProperty(String aAlias) {
        if (StringUtils.isNotBlank(aAlias)) {
            addSelectProperty(ISysRoleDAO.DomainSortIndex, aAlias);
        } else {
            addSelectProperty(ISysRoleDAO.DomainSortIndex, "domainSortIndex");
        }
    }

    public void addDomainIconSelectProperty() {
        addDomainIconSelectProperty("domainIcon");
    }

    public void addDomainIconSelectProperty(String aAlias) {
        if (StringUtils.isNotBlank(aAlias)) {
            addSelectProperty(ISysRoleDAO.DomainIcon, aAlias);
        } else {
            addSelectProperty(ISysRoleDAO.DomainIcon, "domainIcon");
        }
    }

    public void addAllSelectProperties() {
        addIdSelectProperty();

        addDomainIdSelectProperty();

        addRemarksSelectProperty();

        addRoleCodeSelectProperty();

        addRoleNameSelectProperty();

        addRoleTypeSelectProperty();

        addStatusSelectProperty();

        addDefaultFlagSelectProperty();

        addModifyTimeSelectProperty();

        addOperatorIdSelectProperty();

        addOperatorNameSelectProperty();

        addDomainTitleKeySelectProperty();

        addDomainNameSelectProperty();

        addDomainCodeSelectProperty();

        addDomainSortIndexSelectProperty();

        addDomainIconSelectProperty();
    }

    public static class Criteria extends BaseWhereCriterion<SysRoleDAOQueryBean> {
        protected Criteria(SysRoleDAOQueryBean aParentObject) {
            super(aParentObject);
        }

        public Criteria andIdIsNull() {
            addCriterion(ISysRoleDAO.Id + " is null");

            return this;
        }

        public Criteria andIdIsNotNull() {
            addCriterion(ISysRoleDAO.Id + " is not null");

            return this;
        }

        public Criteria andIdIsNotEmpty() {
            addCriterion(ISysRoleDAO.Id + " is not null AND " + ISysRoleDAO.Id +
                " <> ''");

            return this;
        }

        public Criteria andIdIsEmpty() {
            addCriterion("(" + ISysRoleDAO.Id + " is null OR " +
                ISysRoleDAO.Id + " = '')");

            return this;
        }

        public Criteria andIdEqualTo(long value) {
            return andIdEqualTo(Long.valueOf(value));
        }

        public Criteria andIdEqualTo(java.lang.Long value) {
            addCriterion(ISysRoleDAO.Id + " = ", value, "id");

            return this;
        }

        public Criteria andIdEqualToForeignKey(java.lang.String key) {
            StringBuffer str = new StringBuffer(ISysRoleDAO.Id);
            str.append(" = ").append(key);
            addForeignKeyCriterion(str.toString());

            return this;
        }

        public Criteria andIdEqualTo(BaseQueryBean subQueryBean,
            IDataAccessInterface<?, ?> dao) {
            addCriterion(ISysRoleDAO.Id + " = ", subQueryBean, dao);

            return this;
        }

        public Criteria andIdNotEqualTo(long value) {
            return andIdNotEqualTo(Long.valueOf(value));
        }

        public Criteria andIdNotEqualTo(java.lang.Long value) {
            addCriterion(ISysRoleDAO.Id + " <>", value, "id");

            return this;
        }

        public Criteria andIdNotEqualToOrIsNull(long value) {
            return andIdNotEqualToOrIsNull(Long.valueOf(value));
        }

        public Criteria andIdNotEqualToOrIsNull(java.lang.Long value) {
            addCriterion(ISysRoleDAO.Id + " is null OR " + ISysRoleDAO.Id +
                " <>", value, "id");

            return this;
        }

        public Criteria andIdNotEqualToForeignKey(java.lang.String key) {
            StringBuffer str = new StringBuffer(ISysRoleDAO.Id);
            str.append(" <> ").append(key);
            addForeignKeyCriterion(str.toString());

            return this;
        }

        public Criteria andIdNotEqualTo(BaseQueryBean subQueryBean,
            IDataAccessInterface<?, ?> dao) {
            addCriterion(ISysRoleDAO.Id + " <> ", subQueryBean, dao);

            return this;
        }

        public Criteria andIdGreaterThan(long value) {
            return andIdGreaterThan(Long.valueOf(value));
        }

        public Criteria andIdGreaterThan(java.lang.Long value) {
            addCriterion(ISysRoleDAO.Id + " >", value, "id");

            return this;
        }

        public Criteria andIdGreaterThanForeignKey(java.lang.String key) {
            StringBuffer str = new StringBuffer(ISysRoleDAO.Id);
            str.append(" > ").append(key);
            addForeignKeyCriterion(str.toString());

            return this;
        }

        public Criteria andIdGreaterThan(BaseQueryBean subQueryBean,
            IDataAccessInterface<?, ?> dao) {
            addCriterion(ISysRoleDAO.Id + " > ", subQueryBean, dao);

            return this;
        }

        public Criteria andIdGreaterThanOrEqualTo(long value) {
            return andIdGreaterThanOrEqualTo(Long.valueOf(value));
        }

        public Criteria andIdGreaterThanOrEqualTo(java.lang.Long value) {
            addCriterion(ISysRoleDAO.Id + " >=", value, "id");

            return this;
        }

        public Criteria andIdGreaterThanOrEqualToForeignKey(
            java.lang.String key) {
            StringBuffer str = new StringBuffer(ISysRoleDAO.Id);
            str.append(" >= ").append(key);
            addForeignKeyCriterion(str.toString());

            return this;
        }

        public Criteria andIdGreaterThanOrEqualTo(BaseQueryBean subQueryBean,
            IDataAccessInterface<?, ?> dao) {
            addCriterion(ISysRoleDAO.Id + " >= ", subQueryBean, dao);

            return this;
        }

        public Criteria andIdLessThan(long value) {
            return andIdLessThan(Long.valueOf(value));
        }

        public Criteria andIdLessThan(java.lang.Long value) {
            addCriterion(ISysRoleDAO.Id + " <", value, "id");

            return this;
        }

        public Criteria andIdLessThanForeignKey(java.lang.String key) {
            StringBuffer str = new StringBuffer(ISysRoleDAO.Id);
            str.append(" < ").append(key);
            addForeignKeyCriterion(str.toString());

            return this;
        }

        public Criteria andIdLessThan(BaseQueryBean subQueryBean,
            IDataAccessInterface<?, ?> dao) {
            addCriterion(ISysRoleDAO.Id + " < ", subQueryBean, dao);

            return this;
        }

        public Criteria andIdLessThanOrEqualTo(long value) {
            return andIdLessThanOrEqualTo(Long.valueOf(value));
        }

        public Criteria andIdLessThanOrEqualTo(java.lang.Long value) {
            addCriterion(ISysRoleDAO.Id + " <=", value, "id");

            return this;
        }

        public Criteria andIdLessThanOrEqualToForeignKey(java.lang.String key) {
            StringBuffer str = new StringBuffer(ISysRoleDAO.Id);
            str.append(" <= ").append(key);
            addForeignKeyCriterion(str.toString());

            return this;
        }

        public Criteria andIdLessThanOrEqualTo(BaseQueryBean subQueryBean,
            IDataAccessInterface<?, ?> dao) {
            addCriterion(ISysRoleDAO.Id + " <= ", subQueryBean, dao);

            return this;
        }

        public Criteria andIdIn(long[] values) {
            if (values.length == 1) {
                return andIdEqualTo((java.lang.Long) values[0]);
            } else {
                addCriterion(ISysRoleDAO.Id + " in", values, "id");

                return this;
            }
        }

        public Criteria andIdNotIn(long[] values) {
            if (values.length == 1) {
                return andIdNotEqualTo((java.lang.Long) values[0]);
            } else {
                addCriterion(ISysRoleDAO.Id + " not in", values, "id");

                return this;
            }
        }

        public Criteria andIdIn(List<java.lang.Long> values) {
            if (values.size() == 1) {
                return andIdEqualTo(values.get(0));
            } else {
                addCriterion(ISysRoleDAO.Id + " in", values, "id");

                return this;
            }
        }

        public Criteria andIdNotIn(List<java.lang.Long> values) {
            if (values.size() == 1) {
                return andIdNotEqualTo(values.get(0));
            } else {
                addCriterion(ISysRoleDAO.Id + " not in", values, "id");

                return this;
            }
        }

        public Criteria andIdIn(java.lang.Long[] values) {
            if (values.length == 1) {
                return andIdEqualTo(values[0]);
            } else {
                addCriterion(ISysRoleDAO.Id + " in", Arrays.asList(values), "id");

                return this;
            }
        }

        public Criteria andIdNotIn(java.lang.Long[] values) {
            if (values.length == 1) {
                return andIdNotEqualTo(values[0]);
            } else {
                addCriterion(ISysRoleDAO.Id + " not in", Arrays.asList(values),
                    "id");

                return this;
            }
        }

        public Criteria andIdIn(BaseQueryBean subQueryBean,
            IDataAccessInterface<?, ?> dao) {
            addCriterion(ISysRoleDAO.Id + " in ", subQueryBean, dao);

            return this;
        }

        public Criteria andIdNotIn(BaseQueryBean subQueryBean,
            IDataAccessInterface<?, ?> dao) {
            addCriterion(ISysRoleDAO.Id + " not in ", subQueryBean, dao);

            return this;
        }

        public Criteria andIdBetween(long value1, long value2) {
            addCriterion(ISysRoleDAO.Id + " between", value1, value2, "id");

            return this;
        }

        public Criteria andIdBetween(java.lang.Long value1,
            java.lang.Long value2) {
            addCriterion(ISysRoleDAO.Id + " between", value1, value2, "id");

            return this;
        }

        public Criteria andIdNotBetween(long value1, long value2) {
            addCriterion(ISysRoleDAO.Id + " not between", value1, value2, "id");

            return this;
        }

        public Criteria andIdNotBetween(java.lang.Long value1,
            java.lang.Long value2) {
            addCriterion(ISysRoleDAO.Id + " not between", value1, value2, "id");

            return this;
        }

        public Criteria andDomainIdIsNull() {
            addCriterion(ISysRoleDAO.DomainId + " is null");

            return this;
        }

        public Criteria andDomainIdIsNotNull() {
            addCriterion(ISysRoleDAO.DomainId + " is not null");

            return this;
        }

        public Criteria andDomainIdIsNotEmpty() {
            addCriterion(ISysRoleDAO.DomainId + " is not null AND " +
                ISysRoleDAO.DomainId + " <> ''");

            return this;
        }

        public Criteria andDomainIdIsEmpty() {
            addCriterion("(" + ISysRoleDAO.DomainId + " is null OR " +
                ISysRoleDAO.DomainId + " = '')");

            return this;
        }

        public Criteria andDomainIdEqualTo(long value) {
            return andDomainIdEqualTo(Long.valueOf(value));
        }

        public Criteria andDomainIdEqualTo(java.lang.Long value) {
            addCriterion(ISysRoleDAO.DomainId + " = ", value, "domainId");

            return this;
        }

        public Criteria andDomainIdEqualToForeignKey(java.lang.String key) {
            StringBuffer str = new StringBuffer(ISysRoleDAO.DomainId);
            str.append(" = ").append(key);
            addForeignKeyCriterion(str.toString());

            return this;
        }

        public Criteria andDomainIdEqualTo(BaseQueryBean subQueryBean,
            IDataAccessInterface<?, ?> dao) {
            addCriterion(ISysRoleDAO.DomainId + " = ", subQueryBean, dao);

            return this;
        }

        public Criteria andDomainIdNotEqualTo(long value) {
            return andDomainIdNotEqualTo(Long.valueOf(value));
        }

        public Criteria andDomainIdNotEqualTo(java.lang.Long value) {
            addCriterion(ISysRoleDAO.DomainId + " <>", value, "domainId");

            return this;
        }

        public Criteria andDomainIdNotEqualToOrIsNull(long value) {
            return andDomainIdNotEqualToOrIsNull(Long.valueOf(value));
        }

        public Criteria andDomainIdNotEqualToOrIsNull(java.lang.Long value) {
            addCriterion(ISysRoleDAO.DomainId + " is null OR " +
                ISysRoleDAO.DomainId + " <>", value, "domainId");

            return this;
        }

        public Criteria andDomainIdNotEqualToForeignKey(java.lang.String key) {
            StringBuffer str = new StringBuffer(ISysRoleDAO.DomainId);
            str.append(" <> ").append(key);
            addForeignKeyCriterion(str.toString());

            return this;
        }

        public Criteria andDomainIdNotEqualTo(BaseQueryBean subQueryBean,
            IDataAccessInterface<?, ?> dao) {
            addCriterion(ISysRoleDAO.DomainId + " <> ", subQueryBean, dao);

            return this;
        }

        public Criteria andDomainIdGreaterThan(long value) {
            return andDomainIdGreaterThan(Long.valueOf(value));
        }

        public Criteria andDomainIdGreaterThan(java.lang.Long value) {
            addCriterion(ISysRoleDAO.DomainId + " >", value, "domainId");

            return this;
        }

        public Criteria andDomainIdGreaterThanForeignKey(java.lang.String key) {
            StringBuffer str = new StringBuffer(ISysRoleDAO.DomainId);
            str.append(" > ").append(key);
            addForeignKeyCriterion(str.toString());

            return this;
        }

        public Criteria andDomainIdGreaterThan(BaseQueryBean subQueryBean,
            IDataAccessInterface<?, ?> dao) {
            addCriterion(ISysRoleDAO.DomainId + " > ", subQueryBean, dao);

            return this;
        }

        public Criteria andDomainIdGreaterThanOrEqualTo(long value) {
            return andDomainIdGreaterThanOrEqualTo(Long.valueOf(value));
        }

        public Criteria andDomainIdGreaterThanOrEqualTo(java.lang.Long value) {
            addCriterion(ISysRoleDAO.DomainId + " >=", value, "domainId");

            return this;
        }

        public Criteria andDomainIdGreaterThanOrEqualToForeignKey(
            java.lang.String key) {
            StringBuffer str = new StringBuffer(ISysRoleDAO.DomainId);
            str.append(" >= ").append(key);
            addForeignKeyCriterion(str.toString());

            return this;
        }

        public Criteria andDomainIdGreaterThanOrEqualTo(
            BaseQueryBean subQueryBean, IDataAccessInterface<?, ?> dao) {
            addCriterion(ISysRoleDAO.DomainId + " >= ", subQueryBean, dao);

            return this;
        }

        public Criteria andDomainIdLessThan(long value) {
            return andDomainIdLessThan(Long.valueOf(value));
        }

        public Criteria andDomainIdLessThan(java.lang.Long value) {
            addCriterion(ISysRoleDAO.DomainId + " <", value, "domainId");

            return this;
        }

        public Criteria andDomainIdLessThanForeignKey(java.lang.String key) {
            StringBuffer str = new StringBuffer(ISysRoleDAO.DomainId);
            str.append(" < ").append(key);
            addForeignKeyCriterion(str.toString());

            return this;
        }

        public Criteria andDomainIdLessThan(BaseQueryBean subQueryBean,
            IDataAccessInterface<?, ?> dao) {
            addCriterion(ISysRoleDAO.DomainId + " < ", subQueryBean, dao);

            return this;
        }

        public Criteria andDomainIdLessThanOrEqualTo(long value) {
            return andDomainIdLessThanOrEqualTo(Long.valueOf(value));
        }

        public Criteria andDomainIdLessThanOrEqualTo(java.lang.Long value) {
            addCriterion(ISysRoleDAO.DomainId + " <=", value, "domainId");

            return this;
        }

        public Criteria andDomainIdLessThanOrEqualToForeignKey(
            java.lang.String key) {
            StringBuffer str = new StringBuffer(ISysRoleDAO.DomainId);
            str.append(" <= ").append(key);
            addForeignKeyCriterion(str.toString());

            return this;
        }

        public Criteria andDomainIdLessThanOrEqualTo(
            BaseQueryBean subQueryBean, IDataAccessInterface<?, ?> dao) {
            addCriterion(ISysRoleDAO.DomainId + " <= ", subQueryBean, dao);

            return this;
        }

        public Criteria andDomainIdIn(long[] values) {
            if (values.length == 1) {
                return andDomainIdEqualTo((java.lang.Long) values[0]);
            } else {
                addCriterion(ISysRoleDAO.DomainId + " in", values, "domainId");

                return this;
            }
        }

        public Criteria andDomainIdNotIn(long[] values) {
            if (values.length == 1) {
                return andDomainIdNotEqualTo((java.lang.Long) values[0]);
            } else {
                addCriterion(ISysRoleDAO.DomainId + " not in", values,
                    "domainId");

                return this;
            }
        }

        public Criteria andDomainIdIn(List<java.lang.Long> values) {
            if (values.size() == 1) {
                return andDomainIdEqualTo(values.get(0));
            } else {
                addCriterion(ISysRoleDAO.DomainId + " in", values, "domainId");

                return this;
            }
        }

        public Criteria andDomainIdNotIn(List<java.lang.Long> values) {
            if (values.size() == 1) {
                return andDomainIdNotEqualTo(values.get(0));
            } else {
                addCriterion(ISysRoleDAO.DomainId + " not in", values,
                    "domainId");

                return this;
            }
        }

        public Criteria andDomainIdIn(java.lang.Long[] values) {
            if (values.length == 1) {
                return andDomainIdEqualTo(values[0]);
            } else {
                addCriterion(ISysRoleDAO.DomainId + " in",
                    Arrays.asList(values), "domainId");

                return this;
            }
        }

        public Criteria andDomainIdNotIn(java.lang.Long[] values) {
            if (values.length == 1) {
                return andDomainIdNotEqualTo(values[0]);
            } else {
                addCriterion(ISysRoleDAO.DomainId + " not in",
                    Arrays.asList(values), "domainId");

                return this;
            }
        }

        public Criteria andDomainIdIn(BaseQueryBean subQueryBean,
            IDataAccessInterface<?, ?> dao) {
            addCriterion(ISysRoleDAO.DomainId + " in ", subQueryBean, dao);

            return this;
        }

        public Criteria andDomainIdNotIn(BaseQueryBean subQueryBean,
            IDataAccessInterface<?, ?> dao) {
            addCriterion(ISysRoleDAO.DomainId + " not in ", subQueryBean, dao);

            return this;
        }

        public Criteria andDomainIdBetween(long value1, long value2) {
            addCriterion(ISysRoleDAO.DomainId + " between", value1, value2,
                "domainId");

            return this;
        }

        public Criteria andDomainIdBetween(java.lang.Long value1,
            java.lang.Long value2) {
            addCriterion(ISysRoleDAO.DomainId + " between", value1, value2,
                "domainId");

            return this;
        }

        public Criteria andDomainIdNotBetween(long value1, long value2) {
            addCriterion(ISysRoleDAO.DomainId + " not between", value1, value2,
                "domainId");

            return this;
        }

        public Criteria andDomainIdNotBetween(java.lang.Long value1,
            java.lang.Long value2) {
            addCriterion(ISysRoleDAO.DomainId + " not between", value1, value2,
                "domainId");

            return this;
        }

        public Criteria andRemarksIsNull() {
            addCriterion(ISysRoleDAO.Remarks + " is null");

            return this;
        }

        public Criteria andRemarksIsNotNull() {
            addCriterion(ISysRoleDAO.Remarks + " is not null");

            return this;
        }

        public Criteria andRemarksIsNotEmpty() {
            addCriterion(ISysRoleDAO.Remarks + " is not null AND " +
                ISysRoleDAO.Remarks + " <> ''");

            return this;
        }

        public Criteria andRemarksIsEmpty() {
            addCriterion("(" + ISysRoleDAO.Remarks + " is null OR " +
                ISysRoleDAO.Remarks + " = '')");

            return this;
        }

        public Criteria andRemarksEqualTo(String value) {
            addCriterion(ISysRoleDAO.Remarks + " = ", value, "remarks");

            return this;
        }

        public Criteria andRemarksEqualToForeignKey(java.lang.String key) {
            StringBuffer str = new StringBuffer(ISysRoleDAO.Remarks);
            str.append(" = ").append(key);
            addForeignKeyCriterion(str.toString());

            return this;
        }

        public Criteria andRemarksEqualTo(BaseQueryBean subQueryBean,
            IDataAccessInterface<?, ?> dao) {
            addCriterion(ISysRoleDAO.Remarks + " = ", subQueryBean, dao);

            return this;
        }

        public Criteria andRemarksNotEqualTo(String value) {
            addCriterion(ISysRoleDAO.Remarks + " <>", value, "remarks");

            return this;
        }

        public Criteria andRemarksNotEqualToOrIsNull(String value) {
            addCriterion(ISysRoleDAO.Remarks + " is null OR " +
                ISysRoleDAO.Remarks + " <>", value, "remarks");

            return this;
        }

        public Criteria andRemarksNotEqualToForeignKey(java.lang.String key) {
            StringBuffer str = new StringBuffer(ISysRoleDAO.Remarks);
            str.append(" <> ").append(key);
            addForeignKeyCriterion(str.toString());

            return this;
        }

        public Criteria andRemarksNotEqualTo(BaseQueryBean subQueryBean,
            IDataAccessInterface<?, ?> dao) {
            addCriterion(ISysRoleDAO.Remarks + " <> ", subQueryBean, dao);

            return this;
        }

        public Criteria andRemarksGreaterThan(String value) {
            addCriterion(ISysRoleDAO.Remarks + " >", value, "remarks");

            return this;
        }

        public Criteria andRemarksGreaterThanForeignKey(java.lang.String key) {
            StringBuffer str = new StringBuffer(ISysRoleDAO.Remarks);
            str.append(" > ").append(key);
            addForeignKeyCriterion(str.toString());

            return this;
        }

        public Criteria andRemarksGreaterThan(BaseQueryBean subQueryBean,
            IDataAccessInterface<?, ?> dao) {
            addCriterion(ISysRoleDAO.Remarks + " > ", subQueryBean, dao);

            return this;
        }

        public Criteria andRemarksGreaterThanOrEqualTo(String value) {
            addCriterion(ISysRoleDAO.Remarks + " >=", value, "remarks");

            return this;
        }

        public Criteria andRemarksGreaterThanOrEqualToForeignKey(
            java.lang.String key) {
            StringBuffer str = new StringBuffer(ISysRoleDAO.Remarks);
            str.append(" >= ").append(key);
            addForeignKeyCriterion(str.toString());

            return this;
        }

        public Criteria andRemarksGreaterThanOrEqualTo(
            BaseQueryBean subQueryBean, IDataAccessInterface<?, ?> dao) {
            addCriterion(ISysRoleDAO.Remarks + " >= ", subQueryBean, dao);

            return this;
        }

        public Criteria andRemarksLessThan(String value) {
            addCriterion(ISysRoleDAO.Remarks + " <", value, "remarks");

            return this;
        }

        public Criteria andRemarksLessThanForeignKey(java.lang.String key) {
            StringBuffer str = new StringBuffer(ISysRoleDAO.Remarks);
            str.append(" < ").append(key);
            addForeignKeyCriterion(str.toString());

            return this;
        }

        public Criteria andRemarksLessThan(BaseQueryBean subQueryBean,
            IDataAccessInterface<?, ?> dao) {
            addCriterion(ISysRoleDAO.Remarks + " < ", subQueryBean, dao);

            return this;
        }

        public Criteria andRemarksLessThanOrEqualTo(String value) {
            addCriterion(ISysRoleDAO.Remarks + " <=", value, "remarks");

            return this;
        }

        public Criteria andRemarksLessThanOrEqualToForeignKey(
            java.lang.String key) {
            StringBuffer str = new StringBuffer(ISysRoleDAO.Remarks);
            str.append(" <= ").append(key);
            addForeignKeyCriterion(str.toString());

            return this;
        }

        public Criteria andRemarksLessThanOrEqualTo(
            BaseQueryBean subQueryBean, IDataAccessInterface<?, ?> dao) {
            addCriterion(ISysRoleDAO.Remarks + " <= ", subQueryBean, dao);

            return this;
        }

        public Criteria andRemarksLike(String value) {
            StringBuffer buffer = new StringBuffer("%");
            buffer.append(value);
            buffer.append("%");
            addCriterion(ISysRoleDAO.Remarks + " like", buffer.toString(),
                "remarks");

            return this;
        }

        public Criteria andRemarksNotLike(String value) {
            StringBuffer buffer = new StringBuffer("%");
            buffer.append(value);
            buffer.append("%");
            addCriterion(ISysRoleDAO.Remarks + " not like", buffer.toString(),
                "remarks");

            return this;
        }

        public Criteria andRemarksIn(List<String> values) {
            if (values.size() == 1) {
                return andRemarksEqualTo(values.get(0));
            } else {
                addCriterion(ISysRoleDAO.Remarks + " in", values, "remarks");

                return this;
            }
        }

        public Criteria andRemarksNotIn(List<String> values) {
            if (values.size() == 1) {
                return andRemarksNotEqualTo(values.get(0));
            } else {
                addCriterion(ISysRoleDAO.Remarks + " not in", values, "remarks");

                return this;
            }
        }

        public Criteria andRemarksIn(String[] values) {
            if (values.length == 1) {
                return andRemarksEqualTo(values[0]);
            } else {
                addCriterion(ISysRoleDAO.Remarks + " in",
                    Arrays.asList(values), "remarks");

                return this;
            }
        }

        public Criteria andRemarksNotIn(String[] values) {
            if (values.length == 1) {
                return andRemarksNotEqualTo(values[0]);
            } else {
                addCriterion(ISysRoleDAO.Remarks + " not in",
                    Arrays.asList(values), "remarks");

                return this;
            }
        }

        public Criteria andRemarksIn(BaseQueryBean subQueryBean,
            IDataAccessInterface<?, ?> dao) {
            addCriterion(ISysRoleDAO.Remarks + " in ", subQueryBean, dao);

            return this;
        }

        public Criteria andRemarksNotIn(BaseQueryBean subQueryBean,
            IDataAccessInterface<?, ?> dao) {
            addCriterion(ISysRoleDAO.Remarks + " not in ", subQueryBean, dao);

            return this;
        }

        public Criteria andRemarksBetween(String value1, String value2) {
            addCriterion(ISysRoleDAO.Remarks + " between", value1, value2,
                "remarks");

            return this;
        }

        public Criteria andRemarksNotBetween(String value1, String value2) {
            addCriterion(ISysRoleDAO.Remarks + " not between", value1, value2,
                "remarks");

            return this;
        }

        public Criteria andRoleCodeIsNull() {
            addCriterion(ISysRoleDAO.RoleCode + " is null");

            return this;
        }

        public Criteria andRoleCodeIsNotNull() {
            addCriterion(ISysRoleDAO.RoleCode + " is not null");

            return this;
        }

        public Criteria andRoleCodeIsNotEmpty() {
            addCriterion(ISysRoleDAO.RoleCode + " is not null AND " +
                ISysRoleDAO.RoleCode + " <> ''");

            return this;
        }

        public Criteria andRoleCodeIsEmpty() {
            addCriterion("(" + ISysRoleDAO.RoleCode + " is null OR " +
                ISysRoleDAO.RoleCode + " = '')");

            return this;
        }

        public Criteria andRoleCodeEqualTo(String value) {
            addCriterion(ISysRoleDAO.RoleCode + " = ", value, "roleCode");

            return this;
        }

        public Criteria andRoleCodeEqualToForeignKey(java.lang.String key) {
            StringBuffer str = new StringBuffer(ISysRoleDAO.RoleCode);
            str.append(" = ").append(key);
            addForeignKeyCriterion(str.toString());

            return this;
        }

        public Criteria andRoleCodeEqualTo(BaseQueryBean subQueryBean,
            IDataAccessInterface<?, ?> dao) {
            addCriterion(ISysRoleDAO.RoleCode + " = ", subQueryBean, dao);

            return this;
        }

        public Criteria andRoleCodeNotEqualTo(String value) {
            addCriterion(ISysRoleDAO.RoleCode + " <>", value, "roleCode");

            return this;
        }

        public Criteria andRoleCodeNotEqualToOrIsNull(String value) {
            addCriterion(ISysRoleDAO.RoleCode + " is null OR " +
                ISysRoleDAO.RoleCode + " <>", value, "roleCode");

            return this;
        }

        public Criteria andRoleCodeNotEqualToForeignKey(java.lang.String key) {
            StringBuffer str = new StringBuffer(ISysRoleDAO.RoleCode);
            str.append(" <> ").append(key);
            addForeignKeyCriterion(str.toString());

            return this;
        }

        public Criteria andRoleCodeNotEqualTo(BaseQueryBean subQueryBean,
            IDataAccessInterface<?, ?> dao) {
            addCriterion(ISysRoleDAO.RoleCode + " <> ", subQueryBean, dao);

            return this;
        }

        public Criteria andRoleCodeGreaterThan(String value) {
            addCriterion(ISysRoleDAO.RoleCode + " >", value, "roleCode");

            return this;
        }

        public Criteria andRoleCodeGreaterThanForeignKey(java.lang.String key) {
            StringBuffer str = new StringBuffer(ISysRoleDAO.RoleCode);
            str.append(" > ").append(key);
            addForeignKeyCriterion(str.toString());

            return this;
        }

        public Criteria andRoleCodeGreaterThan(BaseQueryBean subQueryBean,
            IDataAccessInterface<?, ?> dao) {
            addCriterion(ISysRoleDAO.RoleCode + " > ", subQueryBean, dao);

            return this;
        }

        public Criteria andRoleCodeGreaterThanOrEqualTo(String value) {
            addCriterion(ISysRoleDAO.RoleCode + " >=", value, "roleCode");

            return this;
        }

        public Criteria andRoleCodeGreaterThanOrEqualToForeignKey(
            java.lang.String key) {
            StringBuffer str = new StringBuffer(ISysRoleDAO.RoleCode);
            str.append(" >= ").append(key);
            addForeignKeyCriterion(str.toString());

            return this;
        }

        public Criteria andRoleCodeGreaterThanOrEqualTo(
            BaseQueryBean subQueryBean, IDataAccessInterface<?, ?> dao) {
            addCriterion(ISysRoleDAO.RoleCode + " >= ", subQueryBean, dao);

            return this;
        }

        public Criteria andRoleCodeLessThan(String value) {
            addCriterion(ISysRoleDAO.RoleCode + " <", value, "roleCode");

            return this;
        }

        public Criteria andRoleCodeLessThanForeignKey(java.lang.String key) {
            StringBuffer str = new StringBuffer(ISysRoleDAO.RoleCode);
            str.append(" < ").append(key);
            addForeignKeyCriterion(str.toString());

            return this;
        }

        public Criteria andRoleCodeLessThan(BaseQueryBean subQueryBean,
            IDataAccessInterface<?, ?> dao) {
            addCriterion(ISysRoleDAO.RoleCode + " < ", subQueryBean, dao);

            return this;
        }

        public Criteria andRoleCodeLessThanOrEqualTo(String value) {
            addCriterion(ISysRoleDAO.RoleCode + " <=", value, "roleCode");

            return this;
        }

        public Criteria andRoleCodeLessThanOrEqualToForeignKey(
            java.lang.String key) {
            StringBuffer str = new StringBuffer(ISysRoleDAO.RoleCode);
            str.append(" <= ").append(key);
            addForeignKeyCriterion(str.toString());

            return this;
        }

        public Criteria andRoleCodeLessThanOrEqualTo(
            BaseQueryBean subQueryBean, IDataAccessInterface<?, ?> dao) {
            addCriterion(ISysRoleDAO.RoleCode + " <= ", subQueryBean, dao);

            return this;
        }

        public Criteria andRoleCodeLike(String value) {
            StringBuffer buffer = new StringBuffer("%");
            buffer.append(value);
            buffer.append("%");
            addCriterion(ISysRoleDAO.RoleCode + " like", buffer.toString(),
                "roleCode");

            return this;
        }

        public Criteria andRoleCodeNotLike(String value) {
            StringBuffer buffer = new StringBuffer("%");
            buffer.append(value);
            buffer.append("%");
            addCriterion(ISysRoleDAO.RoleCode + " not like", buffer.toString(),
                "roleCode");

            return this;
        }

        public Criteria andRoleCodeIn(List<String> values) {
            if (values.size() == 1) {
                return andRoleCodeEqualTo(values.get(0));
            } else {
                addCriterion(ISysRoleDAO.RoleCode + " in", values, "roleCode");

                return this;
            }
        }

        public Criteria andRoleCodeNotIn(List<String> values) {
            if (values.size() == 1) {
                return andRoleCodeNotEqualTo(values.get(0));
            } else {
                addCriterion(ISysRoleDAO.RoleCode + " not in", values,
                    "roleCode");

                return this;
            }
        }

        public Criteria andRoleCodeIn(String[] values) {
            if (values.length == 1) {
                return andRoleCodeEqualTo(values[0]);
            } else {
                addCriterion(ISysRoleDAO.RoleCode + " in",
                    Arrays.asList(values), "roleCode");

                return this;
            }
        }

        public Criteria andRoleCodeNotIn(String[] values) {
            if (values.length == 1) {
                return andRoleCodeNotEqualTo(values[0]);
            } else {
                addCriterion(ISysRoleDAO.RoleCode + " not in",
                    Arrays.asList(values), "roleCode");

                return this;
            }
        }

        public Criteria andRoleCodeIn(BaseQueryBean subQueryBean,
            IDataAccessInterface<?, ?> dao) {
            addCriterion(ISysRoleDAO.RoleCode + " in ", subQueryBean, dao);

            return this;
        }

        public Criteria andRoleCodeNotIn(BaseQueryBean subQueryBean,
            IDataAccessInterface<?, ?> dao) {
            addCriterion(ISysRoleDAO.RoleCode + " not in ", subQueryBean, dao);

            return this;
        }

        public Criteria andRoleCodeBetween(String value1, String value2) {
            addCriterion(ISysRoleDAO.RoleCode + " between", value1, value2,
                "roleCode");

            return this;
        }

        public Criteria andRoleCodeNotBetween(String value1, String value2) {
            addCriterion(ISysRoleDAO.RoleCode + " not between", value1, value2,
                "roleCode");

            return this;
        }

        public Criteria andRoleNameIsNull() {
            addCriterion(ISysRoleDAO.RoleName + " is null");

            return this;
        }

        public Criteria andRoleNameIsNotNull() {
            addCriterion(ISysRoleDAO.RoleName + " is not null");

            return this;
        }

        public Criteria andRoleNameIsNotEmpty() {
            addCriterion(ISysRoleDAO.RoleName + " is not null AND " +
                ISysRoleDAO.RoleName + " <> ''");

            return this;
        }

        public Criteria andRoleNameIsEmpty() {
            addCriterion("(" + ISysRoleDAO.RoleName + " is null OR " +
                ISysRoleDAO.RoleName + " = '')");

            return this;
        }

        public Criteria andRoleNameEqualTo(String value) {
            addCriterion(ISysRoleDAO.RoleName + " = ", value, "roleName");

            return this;
        }

        public Criteria andRoleNameEqualToForeignKey(java.lang.String key) {
            StringBuffer str = new StringBuffer(ISysRoleDAO.RoleName);
            str.append(" = ").append(key);
            addForeignKeyCriterion(str.toString());

            return this;
        }

        public Criteria andRoleNameEqualTo(BaseQueryBean subQueryBean,
            IDataAccessInterface<?, ?> dao) {
            addCriterion(ISysRoleDAO.RoleName + " = ", subQueryBean, dao);

            return this;
        }

        public Criteria andRoleNameNotEqualTo(String value) {
            addCriterion(ISysRoleDAO.RoleName + " <>", value, "roleName");

            return this;
        }

        public Criteria andRoleNameNotEqualToOrIsNull(String value) {
            addCriterion(ISysRoleDAO.RoleName + " is null OR " +
                ISysRoleDAO.RoleName + " <>", value, "roleName");

            return this;
        }

        public Criteria andRoleNameNotEqualToForeignKey(java.lang.String key) {
            StringBuffer str = new StringBuffer(ISysRoleDAO.RoleName);
            str.append(" <> ").append(key);
            addForeignKeyCriterion(str.toString());

            return this;
        }

        public Criteria andRoleNameNotEqualTo(BaseQueryBean subQueryBean,
            IDataAccessInterface<?, ?> dao) {
            addCriterion(ISysRoleDAO.RoleName + " <> ", subQueryBean, dao);

            return this;
        }

        public Criteria andRoleNameGreaterThan(String value) {
            addCriterion(ISysRoleDAO.RoleName + " >", value, "roleName");

            return this;
        }

        public Criteria andRoleNameGreaterThanForeignKey(java.lang.String key) {
            StringBuffer str = new StringBuffer(ISysRoleDAO.RoleName);
            str.append(" > ").append(key);
            addForeignKeyCriterion(str.toString());

            return this;
        }

        public Criteria andRoleNameGreaterThan(BaseQueryBean subQueryBean,
            IDataAccessInterface<?, ?> dao) {
            addCriterion(ISysRoleDAO.RoleName + " > ", subQueryBean, dao);

            return this;
        }

        public Criteria andRoleNameGreaterThanOrEqualTo(String value) {
            addCriterion(ISysRoleDAO.RoleName + " >=", value, "roleName");

            return this;
        }

        public Criteria andRoleNameGreaterThanOrEqualToForeignKey(
            java.lang.String key) {
            StringBuffer str = new StringBuffer(ISysRoleDAO.RoleName);
            str.append(" >= ").append(key);
            addForeignKeyCriterion(str.toString());

            return this;
        }

        public Criteria andRoleNameGreaterThanOrEqualTo(
            BaseQueryBean subQueryBean, IDataAccessInterface<?, ?> dao) {
            addCriterion(ISysRoleDAO.RoleName + " >= ", subQueryBean, dao);

            return this;
        }

        public Criteria andRoleNameLessThan(String value) {
            addCriterion(ISysRoleDAO.RoleName + " <", value, "roleName");

            return this;
        }

        public Criteria andRoleNameLessThanForeignKey(java.lang.String key) {
            StringBuffer str = new StringBuffer(ISysRoleDAO.RoleName);
            str.append(" < ").append(key);
            addForeignKeyCriterion(str.toString());

            return this;
        }

        public Criteria andRoleNameLessThan(BaseQueryBean subQueryBean,
            IDataAccessInterface<?, ?> dao) {
            addCriterion(ISysRoleDAO.RoleName + " < ", subQueryBean, dao);

            return this;
        }

        public Criteria andRoleNameLessThanOrEqualTo(String value) {
            addCriterion(ISysRoleDAO.RoleName + " <=", value, "roleName");

            return this;
        }

        public Criteria andRoleNameLessThanOrEqualToForeignKey(
            java.lang.String key) {
            StringBuffer str = new StringBuffer(ISysRoleDAO.RoleName);
            str.append(" <= ").append(key);
            addForeignKeyCriterion(str.toString());

            return this;
        }

        public Criteria andRoleNameLessThanOrEqualTo(
            BaseQueryBean subQueryBean, IDataAccessInterface<?, ?> dao) {
            addCriterion(ISysRoleDAO.RoleName + " <= ", subQueryBean, dao);

            return this;
        }

        public Criteria andRoleNameLike(String value) {
            StringBuffer buffer = new StringBuffer("%");
            buffer.append(value);
            buffer.append("%");
            addCriterion(ISysRoleDAO.RoleName + " like", buffer.toString(),
                "roleName");

            return this;
        }

        public Criteria andRoleNameNotLike(String value) {
            StringBuffer buffer = new StringBuffer("%");
            buffer.append(value);
            buffer.append("%");
            addCriterion(ISysRoleDAO.RoleName + " not like", buffer.toString(),
                "roleName");

            return this;
        }

        public Criteria andRoleNameIn(List<String> values) {
            if (values.size() == 1) {
                return andRoleNameEqualTo(values.get(0));
            } else {
                addCriterion(ISysRoleDAO.RoleName + " in", values, "roleName");

                return this;
            }
        }

        public Criteria andRoleNameNotIn(List<String> values) {
            if (values.size() == 1) {
                return andRoleNameNotEqualTo(values.get(0));
            } else {
                addCriterion(ISysRoleDAO.RoleName + " not in", values,
                    "roleName");

                return this;
            }
        }

        public Criteria andRoleNameIn(String[] values) {
            if (values.length == 1) {
                return andRoleNameEqualTo(values[0]);
            } else {
                addCriterion(ISysRoleDAO.RoleName + " in",
                    Arrays.asList(values), "roleName");

                return this;
            }
        }

        public Criteria andRoleNameNotIn(String[] values) {
            if (values.length == 1) {
                return andRoleNameNotEqualTo(values[0]);
            } else {
                addCriterion(ISysRoleDAO.RoleName + " not in",
                    Arrays.asList(values), "roleName");

                return this;
            }
        }

        public Criteria andRoleNameIn(BaseQueryBean subQueryBean,
            IDataAccessInterface<?, ?> dao) {
            addCriterion(ISysRoleDAO.RoleName + " in ", subQueryBean, dao);

            return this;
        }

        public Criteria andRoleNameNotIn(BaseQueryBean subQueryBean,
            IDataAccessInterface<?, ?> dao) {
            addCriterion(ISysRoleDAO.RoleName + " not in ", subQueryBean, dao);

            return this;
        }

        public Criteria andRoleNameBetween(String value1, String value2) {
            addCriterion(ISysRoleDAO.RoleName + " between", value1, value2,
                "roleName");

            return this;
        }

        public Criteria andRoleNameNotBetween(String value1, String value2) {
            addCriterion(ISysRoleDAO.RoleName + " not between", value1, value2,
                "roleName");

            return this;
        }

        public Criteria andRoleTypeIsNull() {
            addCriterion(ISysRoleDAO.RoleType + " is null");

            return this;
        }

        public Criteria andRoleTypeIsNotNull() {
            addCriterion(ISysRoleDAO.RoleType + " is not null");

            return this;
        }

        public Criteria andRoleTypeIsNotEmpty() {
            addCriterion(ISysRoleDAO.RoleType + " is not null AND " +
                ISysRoleDAO.RoleType + " <> ''");

            return this;
        }

        public Criteria andRoleTypeIsEmpty() {
            addCriterion("(" + ISysRoleDAO.RoleType + " is null OR " +
                ISysRoleDAO.RoleType + " = '')");

            return this;
        }

        public Criteria andRoleTypeEqualTo(String value) {
            addCriterion(ISysRoleDAO.RoleType + " = ", value, "roleType");

            return this;
        }

        public Criteria andRoleTypeEqualToForeignKey(java.lang.String key) {
            StringBuffer str = new StringBuffer(ISysRoleDAO.RoleType);
            str.append(" = ").append(key);
            addForeignKeyCriterion(str.toString());

            return this;
        }

        public Criteria andRoleTypeEqualTo(BaseQueryBean subQueryBean,
            IDataAccessInterface<?, ?> dao) {
            addCriterion(ISysRoleDAO.RoleType + " = ", subQueryBean, dao);

            return this;
        }

        public Criteria andRoleTypeNotEqualTo(String value) {
            addCriterion(ISysRoleDAO.RoleType + " <>", value, "roleType");

            return this;
        }

        public Criteria andRoleTypeNotEqualToOrIsNull(String value) {
            addCriterion(ISysRoleDAO.RoleType + " is null OR " +
                ISysRoleDAO.RoleType + " <>", value, "roleType");

            return this;
        }

        public Criteria andRoleTypeNotEqualToForeignKey(java.lang.String key) {
            StringBuffer str = new StringBuffer(ISysRoleDAO.RoleType);
            str.append(" <> ").append(key);
            addForeignKeyCriterion(str.toString());

            return this;
        }

        public Criteria andRoleTypeNotEqualTo(BaseQueryBean subQueryBean,
            IDataAccessInterface<?, ?> dao) {
            addCriterion(ISysRoleDAO.RoleType + " <> ", subQueryBean, dao);

            return this;
        }

        public Criteria andRoleTypeGreaterThan(String value) {
            addCriterion(ISysRoleDAO.RoleType + " >", value, "roleType");

            return this;
        }

        public Criteria andRoleTypeGreaterThanForeignKey(java.lang.String key) {
            StringBuffer str = new StringBuffer(ISysRoleDAO.RoleType);
            str.append(" > ").append(key);
            addForeignKeyCriterion(str.toString());

            return this;
        }

        public Criteria andRoleTypeGreaterThan(BaseQueryBean subQueryBean,
            IDataAccessInterface<?, ?> dao) {
            addCriterion(ISysRoleDAO.RoleType + " > ", subQueryBean, dao);

            return this;
        }

        public Criteria andRoleTypeGreaterThanOrEqualTo(String value) {
            addCriterion(ISysRoleDAO.RoleType + " >=", value, "roleType");

            return this;
        }

        public Criteria andRoleTypeGreaterThanOrEqualToForeignKey(
            java.lang.String key) {
            StringBuffer str = new StringBuffer(ISysRoleDAO.RoleType);
            str.append(" >= ").append(key);
            addForeignKeyCriterion(str.toString());

            return this;
        }

        public Criteria andRoleTypeGreaterThanOrEqualTo(
            BaseQueryBean subQueryBean, IDataAccessInterface<?, ?> dao) {
            addCriterion(ISysRoleDAO.RoleType + " >= ", subQueryBean, dao);

            return this;
        }

        public Criteria andRoleTypeLessThan(String value) {
            addCriterion(ISysRoleDAO.RoleType + " <", value, "roleType");

            return this;
        }

        public Criteria andRoleTypeLessThanForeignKey(java.lang.String key) {
            StringBuffer str = new StringBuffer(ISysRoleDAO.RoleType);
            str.append(" < ").append(key);
            addForeignKeyCriterion(str.toString());

            return this;
        }

        public Criteria andRoleTypeLessThan(BaseQueryBean subQueryBean,
            IDataAccessInterface<?, ?> dao) {
            addCriterion(ISysRoleDAO.RoleType + " < ", subQueryBean, dao);

            return this;
        }

        public Criteria andRoleTypeLessThanOrEqualTo(String value) {
            addCriterion(ISysRoleDAO.RoleType + " <=", value, "roleType");

            return this;
        }

        public Criteria andRoleTypeLessThanOrEqualToForeignKey(
            java.lang.String key) {
            StringBuffer str = new StringBuffer(ISysRoleDAO.RoleType);
            str.append(" <= ").append(key);
            addForeignKeyCriterion(str.toString());

            return this;
        }

        public Criteria andRoleTypeLessThanOrEqualTo(
            BaseQueryBean subQueryBean, IDataAccessInterface<?, ?> dao) {
            addCriterion(ISysRoleDAO.RoleType + " <= ", subQueryBean, dao);

            return this;
        }

        public Criteria andRoleTypeLike(String value) {
            StringBuffer buffer = new StringBuffer("%");
            buffer.append(value);
            buffer.append("%");
            addCriterion(ISysRoleDAO.RoleType + " like", buffer.toString(),
                "roleType");

            return this;
        }

        public Criteria andRoleTypeNotLike(String value) {
            StringBuffer buffer = new StringBuffer("%");
            buffer.append(value);
            buffer.append("%");
            addCriterion(ISysRoleDAO.RoleType + " not like", buffer.toString(),
                "roleType");

            return this;
        }

        public Criteria andRoleTypeIn(List<String> values) {
            if (values.size() == 1) {
                return andRoleTypeEqualTo(values.get(0));
            } else {
                addCriterion(ISysRoleDAO.RoleType + " in", values, "roleType");

                return this;
            }
        }

        public Criteria andRoleTypeNotIn(List<String> values) {
            if (values.size() == 1) {
                return andRoleTypeNotEqualTo(values.get(0));
            } else {
                addCriterion(ISysRoleDAO.RoleType + " not in", values,
                    "roleType");

                return this;
            }
        }

        public Criteria andRoleTypeIn(String[] values) {
            if (values.length == 1) {
                return andRoleTypeEqualTo(values[0]);
            } else {
                addCriterion(ISysRoleDAO.RoleType + " in",
                    Arrays.asList(values), "roleType");

                return this;
            }
        }

        public Criteria andRoleTypeNotIn(String[] values) {
            if (values.length == 1) {
                return andRoleTypeNotEqualTo(values[0]);
            } else {
                addCriterion(ISysRoleDAO.RoleType + " not in",
                    Arrays.asList(values), "roleType");

                return this;
            }
        }

        public Criteria andRoleTypeIn(BaseQueryBean subQueryBean,
            IDataAccessInterface<?, ?> dao) {
            addCriterion(ISysRoleDAO.RoleType + " in ", subQueryBean, dao);

            return this;
        }

        public Criteria andRoleTypeNotIn(BaseQueryBean subQueryBean,
            IDataAccessInterface<?, ?> dao) {
            addCriterion(ISysRoleDAO.RoleType + " not in ", subQueryBean, dao);

            return this;
        }

        public Criteria andRoleTypeBetween(String value1, String value2) {
            addCriterion(ISysRoleDAO.RoleType + " between", value1, value2,
                "roleType");

            return this;
        }

        public Criteria andRoleTypeNotBetween(String value1, String value2) {
            addCriterion(ISysRoleDAO.RoleType + " not between", value1, value2,
                "roleType");

            return this;
        }

        public Criteria andStatusIsNull() {
            addCriterion(ISysRoleDAO.Status + " is null");

            return this;
        }

        public Criteria andStatusIsNotNull() {
            addCriterion(ISysRoleDAO.Status + " is not null");

            return this;
        }

        public Criteria andStatusIsNotEmpty() {
            addCriterion(ISysRoleDAO.Status + " is not null AND " +
                ISysRoleDAO.Status + " <> ''");

            return this;
        }

        public Criteria andStatusIsEmpty() {
            addCriterion("(" + ISysRoleDAO.Status + " is null OR " +
                ISysRoleDAO.Status + " = '')");

            return this;
        }

        public Criteria andStatusEqualTo(String value) {
            addCriterion(ISysRoleDAO.Status + " = ", value, "status");

            return this;
        }

        public Criteria andStatusEqualToForeignKey(java.lang.String key) {
            StringBuffer str = new StringBuffer(ISysRoleDAO.Status);
            str.append(" = ").append(key);
            addForeignKeyCriterion(str.toString());

            return this;
        }

        public Criteria andStatusEqualTo(BaseQueryBean subQueryBean,
            IDataAccessInterface<?, ?> dao) {
            addCriterion(ISysRoleDAO.Status + " = ", subQueryBean, dao);

            return this;
        }

        public Criteria andStatusNotEqualTo(String value) {
            addCriterion(ISysRoleDAO.Status + " <>", value, "status");

            return this;
        }

        public Criteria andStatusNotEqualToOrIsNull(String value) {
            addCriterion(ISysRoleDAO.Status + " is null OR " +
                ISysRoleDAO.Status + " <>", value, "status");

            return this;
        }

        public Criteria andStatusNotEqualToForeignKey(java.lang.String key) {
            StringBuffer str = new StringBuffer(ISysRoleDAO.Status);
            str.append(" <> ").append(key);
            addForeignKeyCriterion(str.toString());

            return this;
        }

        public Criteria andStatusNotEqualTo(BaseQueryBean subQueryBean,
            IDataAccessInterface<?, ?> dao) {
            addCriterion(ISysRoleDAO.Status + " <> ", subQueryBean, dao);

            return this;
        }

        public Criteria andStatusGreaterThan(String value) {
            addCriterion(ISysRoleDAO.Status + " >", value, "status");

            return this;
        }

        public Criteria andStatusGreaterThanForeignKey(java.lang.String key) {
            StringBuffer str = new StringBuffer(ISysRoleDAO.Status);
            str.append(" > ").append(key);
            addForeignKeyCriterion(str.toString());

            return this;
        }

        public Criteria andStatusGreaterThan(BaseQueryBean subQueryBean,
            IDataAccessInterface<?, ?> dao) {
            addCriterion(ISysRoleDAO.Status + " > ", subQueryBean, dao);

            return this;
        }

        public Criteria andStatusGreaterThanOrEqualTo(String value) {
            addCriterion(ISysRoleDAO.Status + " >=", value, "status");

            return this;
        }

        public Criteria andStatusGreaterThanOrEqualToForeignKey(
            java.lang.String key) {
            StringBuffer str = new StringBuffer(ISysRoleDAO.Status);
            str.append(" >= ").append(key);
            addForeignKeyCriterion(str.toString());

            return this;
        }

        public Criteria andStatusGreaterThanOrEqualTo(
            BaseQueryBean subQueryBean, IDataAccessInterface<?, ?> dao) {
            addCriterion(ISysRoleDAO.Status + " >= ", subQueryBean, dao);

            return this;
        }

        public Criteria andStatusLessThan(String value) {
            addCriterion(ISysRoleDAO.Status + " <", value, "status");

            return this;
        }

        public Criteria andStatusLessThanForeignKey(java.lang.String key) {
            StringBuffer str = new StringBuffer(ISysRoleDAO.Status);
            str.append(" < ").append(key);
            addForeignKeyCriterion(str.toString());

            return this;
        }

        public Criteria andStatusLessThan(BaseQueryBean subQueryBean,
            IDataAccessInterface<?, ?> dao) {
            addCriterion(ISysRoleDAO.Status + " < ", subQueryBean, dao);

            return this;
        }

        public Criteria andStatusLessThanOrEqualTo(String value) {
            addCriterion(ISysRoleDAO.Status + " <=", value, "status");

            return this;
        }

        public Criteria andStatusLessThanOrEqualToForeignKey(
            java.lang.String key) {
            StringBuffer str = new StringBuffer(ISysRoleDAO.Status);
            str.append(" <= ").append(key);
            addForeignKeyCriterion(str.toString());

            return this;
        }

        public Criteria andStatusLessThanOrEqualTo(BaseQueryBean subQueryBean,
            IDataAccessInterface<?, ?> dao) {
            addCriterion(ISysRoleDAO.Status + " <= ", subQueryBean, dao);

            return this;
        }

        public Criteria andStatusLike(String value) {
            StringBuffer buffer = new StringBuffer("%");
            buffer.append(value);
            buffer.append("%");
            addCriterion(ISysRoleDAO.Status + " like", buffer.toString(),
                "status");

            return this;
        }

        public Criteria andStatusNotLike(String value) {
            StringBuffer buffer = new StringBuffer("%");
            buffer.append(value);
            buffer.append("%");
            addCriterion(ISysRoleDAO.Status + " not like", buffer.toString(),
                "status");

            return this;
        }

        public Criteria andStatusIn(List<String> values) {
            if (values.size() == 1) {
                return andStatusEqualTo(values.get(0));
            } else {
                addCriterion(ISysRoleDAO.Status + " in", values, "status");

                return this;
            }
        }

        public Criteria andStatusNotIn(List<String> values) {
            if (values.size() == 1) {
                return andStatusNotEqualTo(values.get(0));
            } else {
                addCriterion(ISysRoleDAO.Status + " not in", values, "status");

                return this;
            }
        }

        public Criteria andStatusIn(String[] values) {
            if (values.length == 1) {
                return andStatusEqualTo(values[0]);
            } else {
                addCriterion(ISysRoleDAO.Status + " in", Arrays.asList(values),
                    "status");

                return this;
            }
        }

        public Criteria andStatusNotIn(String[] values) {
            if (values.length == 1) {
                return andStatusNotEqualTo(values[0]);
            } else {
                addCriterion(ISysRoleDAO.Status + " not in",
                    Arrays.asList(values), "status");

                return this;
            }
        }

        public Criteria andStatusIn(BaseQueryBean subQueryBean,
            IDataAccessInterface<?, ?> dao) {
            addCriterion(ISysRoleDAO.Status + " in ", subQueryBean, dao);

            return this;
        }

        public Criteria andStatusNotIn(BaseQueryBean subQueryBean,
            IDataAccessInterface<?, ?> dao) {
            addCriterion(ISysRoleDAO.Status + " not in ", subQueryBean, dao);

            return this;
        }

        public Criteria andStatusBetween(String value1, String value2) {
            addCriterion(ISysRoleDAO.Status + " between", value1, value2,
                "status");

            return this;
        }

        public Criteria andStatusNotBetween(String value1, String value2) {
            addCriterion(ISysRoleDAO.Status + " not between", value1, value2,
                "status");

            return this;
        }

        public Criteria andDefaultFlagIsNull() {
            addCriterion(ISysRoleDAO.DefaultFlag + " is null");

            return this;
        }

        public Criteria andDefaultFlagIsNotNull() {
            addCriterion(ISysRoleDAO.DefaultFlag + " is not null");

            return this;
        }

        public Criteria andDefaultFlagIsNotEmpty() {
            addCriterion(ISysRoleDAO.DefaultFlag + " is not null AND " +
                ISysRoleDAO.DefaultFlag + " <> ''");

            return this;
        }

        public Criteria andDefaultFlagIsEmpty() {
            addCriterion("(" + ISysRoleDAO.DefaultFlag + " is null OR " +
                ISysRoleDAO.DefaultFlag + " = '')");

            return this;
        }

        public Criteria andDefaultFlagEqualTo(String value) {
            addCriterion(ISysRoleDAO.DefaultFlag + " = ", value, "defaultFlag");

            return this;
        }

        public Criteria andDefaultFlagEqualToForeignKey(java.lang.String key) {
            StringBuffer str = new StringBuffer(ISysRoleDAO.DefaultFlag);
            str.append(" = ").append(key);
            addForeignKeyCriterion(str.toString());

            return this;
        }

        public Criteria andDefaultFlagEqualTo(BaseQueryBean subQueryBean,
            IDataAccessInterface<?, ?> dao) {
            addCriterion(ISysRoleDAO.DefaultFlag + " = ", subQueryBean, dao);

            return this;
        }

        public Criteria andDefaultFlagNotEqualTo(String value) {
            addCriterion(ISysRoleDAO.DefaultFlag + " <>", value, "defaultFlag");

            return this;
        }

        public Criteria andDefaultFlagNotEqualToOrIsNull(String value) {
            addCriterion(ISysRoleDAO.DefaultFlag + " is null OR " +
                ISysRoleDAO.DefaultFlag + " <>", value, "defaultFlag");

            return this;
        }

        public Criteria andDefaultFlagNotEqualToForeignKey(java.lang.String key) {
            StringBuffer str = new StringBuffer(ISysRoleDAO.DefaultFlag);
            str.append(" <> ").append(key);
            addForeignKeyCriterion(str.toString());

            return this;
        }

        public Criteria andDefaultFlagNotEqualTo(BaseQueryBean subQueryBean,
            IDataAccessInterface<?, ?> dao) {
            addCriterion(ISysRoleDAO.DefaultFlag + " <> ", subQueryBean, dao);

            return this;
        }

        public Criteria andDefaultFlagGreaterThan(String value) {
            addCriterion(ISysRoleDAO.DefaultFlag + " >", value, "defaultFlag");

            return this;
        }

        public Criteria andDefaultFlagGreaterThanForeignKey(
            java.lang.String key) {
            StringBuffer str = new StringBuffer(ISysRoleDAO.DefaultFlag);
            str.append(" > ").append(key);
            addForeignKeyCriterion(str.toString());

            return this;
        }

        public Criteria andDefaultFlagGreaterThan(BaseQueryBean subQueryBean,
            IDataAccessInterface<?, ?> dao) {
            addCriterion(ISysRoleDAO.DefaultFlag + " > ", subQueryBean, dao);

            return this;
        }

        public Criteria andDefaultFlagGreaterThanOrEqualTo(String value) {
            addCriterion(ISysRoleDAO.DefaultFlag + " >=", value, "defaultFlag");

            return this;
        }

        public Criteria andDefaultFlagGreaterThanOrEqualToForeignKey(
            java.lang.String key) {
            StringBuffer str = new StringBuffer(ISysRoleDAO.DefaultFlag);
            str.append(" >= ").append(key);
            addForeignKeyCriterion(str.toString());

            return this;
        }

        public Criteria andDefaultFlagGreaterThanOrEqualTo(
            BaseQueryBean subQueryBean, IDataAccessInterface<?, ?> dao) {
            addCriterion(ISysRoleDAO.DefaultFlag + " >= ", subQueryBean, dao);

            return this;
        }

        public Criteria andDefaultFlagLessThan(String value) {
            addCriterion(ISysRoleDAO.DefaultFlag + " <", value, "defaultFlag");

            return this;
        }

        public Criteria andDefaultFlagLessThanForeignKey(java.lang.String key) {
            StringBuffer str = new StringBuffer(ISysRoleDAO.DefaultFlag);
            str.append(" < ").append(key);
            addForeignKeyCriterion(str.toString());

            return this;
        }

        public Criteria andDefaultFlagLessThan(BaseQueryBean subQueryBean,
            IDataAccessInterface<?, ?> dao) {
            addCriterion(ISysRoleDAO.DefaultFlag + " < ", subQueryBean, dao);

            return this;
        }

        public Criteria andDefaultFlagLessThanOrEqualTo(String value) {
            addCriterion(ISysRoleDAO.DefaultFlag + " <=", value, "defaultFlag");

            return this;
        }

        public Criteria andDefaultFlagLessThanOrEqualToForeignKey(
            java.lang.String key) {
            StringBuffer str = new StringBuffer(ISysRoleDAO.DefaultFlag);
            str.append(" <= ").append(key);
            addForeignKeyCriterion(str.toString());

            return this;
        }

        public Criteria andDefaultFlagLessThanOrEqualTo(
            BaseQueryBean subQueryBean, IDataAccessInterface<?, ?> dao) {
            addCriterion(ISysRoleDAO.DefaultFlag + " <= ", subQueryBean, dao);

            return this;
        }

        public Criteria andDefaultFlagLike(String value) {
            StringBuffer buffer = new StringBuffer("%");
            buffer.append(value);
            buffer.append("%");
            addCriterion(ISysRoleDAO.DefaultFlag + " like", buffer.toString(),
                "defaultFlag");

            return this;
        }

        public Criteria andDefaultFlagNotLike(String value) {
            StringBuffer buffer = new StringBuffer("%");
            buffer.append(value);
            buffer.append("%");
            addCriterion(ISysRoleDAO.DefaultFlag + " not like",
                buffer.toString(), "defaultFlag");

            return this;
        }

        public Criteria andDefaultFlagIn(List<String> values) {
            if (values.size() == 1) {
                return andDefaultFlagEqualTo(values.get(0));
            } else {
                addCriterion(ISysRoleDAO.DefaultFlag + " in", values,
                    "defaultFlag");

                return this;
            }
        }

        public Criteria andDefaultFlagNotIn(List<String> values) {
            if (values.size() == 1) {
                return andDefaultFlagNotEqualTo(values.get(0));
            } else {
                addCriterion(ISysRoleDAO.DefaultFlag + " not in", values,
                    "defaultFlag");

                return this;
            }
        }

        public Criteria andDefaultFlagIn(String[] values) {
            if (values.length == 1) {
                return andDefaultFlagEqualTo(values[0]);
            } else {
                addCriterion(ISysRoleDAO.DefaultFlag + " in",
                    Arrays.asList(values), "defaultFlag");

                return this;
            }
        }

        public Criteria andDefaultFlagNotIn(String[] values) {
            if (values.length == 1) {
                return andDefaultFlagNotEqualTo(values[0]);
            } else {
                addCriterion(ISysRoleDAO.DefaultFlag + " not in",
                    Arrays.asList(values), "defaultFlag");

                return this;
            }
        }

        public Criteria andDefaultFlagIn(BaseQueryBean subQueryBean,
            IDataAccessInterface<?, ?> dao) {
            addCriterion(ISysRoleDAO.DefaultFlag + " in ", subQueryBean, dao);

            return this;
        }

        public Criteria andDefaultFlagNotIn(BaseQueryBean subQueryBean,
            IDataAccessInterface<?, ?> dao) {
            addCriterion(ISysRoleDAO.DefaultFlag + " not in ", subQueryBean, dao);

            return this;
        }

        public Criteria andDefaultFlagBetween(String value1, String value2) {
            addCriterion(ISysRoleDAO.DefaultFlag + " between", value1, value2,
                "defaultFlag");

            return this;
        }

        public Criteria andDefaultFlagNotBetween(String value1, String value2) {
            addCriterion(ISysRoleDAO.DefaultFlag + " not between", value1,
                value2, "defaultFlag");

            return this;
        }

        public Criteria andModifyTimeIsNull() {
            addCriterion(ISysRoleDAO.ModifyTime + " is null");

            return this;
        }

        public Criteria andModifyTimeIsNotNull() {
            addCriterion(ISysRoleDAO.ModifyTime + " is not null");

            return this;
        }

        public Criteria andModifyTimeIsNotEmpty() {
            addCriterion(ISysRoleDAO.ModifyTime + " is not null AND " +
                ISysRoleDAO.ModifyTime + " <> ''");

            return this;
        }

        public Criteria andModifyTimeIsEmpty() {
            addCriterion("(" + ISysRoleDAO.ModifyTime + " is null OR " +
                ISysRoleDAO.ModifyTime + " = '')");

            return this;
        }

        public Criteria andModifyTimeEqualTo(java.util.Date value) {
            addCriterionForJDBCDate(ISysRoleDAO.ModifyTime + " = ", value,
                "modifyTime");

            return this;
        }

        public Criteria andModifyTimeEqualToForeignKey(java.lang.String key) {
            StringBuffer str = new StringBuffer(ISysRoleDAO.ModifyTime);
            str.append(" = ").append(key);
            addForeignKeyCriterion(str.toString());

            return this;
        }

        public Criteria andModifyTimeEqualTo(BaseQueryBean subQueryBean,
            IDataAccessInterface<?, ?> dao) {
            addCriterion(ISysRoleDAO.ModifyTime + " = ", subQueryBean, dao);

            return this;
        }

        public Criteria andModifyTimeNotEqualTo(java.util.Date value) {
            addCriterionForJDBCDate(ISysRoleDAO.ModifyTime + " <>", value,
                "modifyTime");

            return this;
        }

        public Criteria andModifyTimeNotEqualToOrIsNull(java.util.Date value) {
            addCriterionForJDBCDate(ISysRoleDAO.ModifyTime + " is null OR " +
                ISysRoleDAO.ModifyTime + " <>", value, "modifyTime");

            return this;
        }

        public Criteria andModifyTimeNotEqualToForeignKey(java.lang.String key) {
            StringBuffer str = new StringBuffer(ISysRoleDAO.ModifyTime);
            str.append(" <> ").append(key);
            addForeignKeyCriterion(str.toString());

            return this;
        }

        public Criteria andModifyTimeNotEqualTo(BaseQueryBean subQueryBean,
            IDataAccessInterface<?, ?> dao) {
            addCriterion(ISysRoleDAO.ModifyTime + " <> ", subQueryBean, dao);

            return this;
        }

        public Criteria andModifyTimeGreaterThan(java.util.Date value) {
            addCriterionForJDBCDate(ISysRoleDAO.ModifyTime + " >", value,
                "modifyTime");

            return this;
        }

        public Criteria andModifyTimeGreaterThanForeignKey(java.lang.String key) {
            StringBuffer str = new StringBuffer(ISysRoleDAO.ModifyTime);
            str.append(" > ").append(key);
            addForeignKeyCriterion(str.toString());

            return this;
        }

        public Criteria andModifyTimeGreaterThan(BaseQueryBean subQueryBean,
            IDataAccessInterface<?, ?> dao) {
            addCriterion(ISysRoleDAO.ModifyTime + " > ", subQueryBean, dao);

            return this;
        }

        public Criteria andModifyTimeGreaterThanOrEqualTo(java.util.Date value) {
            addCriterionForJDBCDate(ISysRoleDAO.ModifyTime + " >=", value,
                "modifyTime");

            return this;
        }

        public Criteria andModifyTimeGreaterThanOrEqualToForeignKey(
            java.lang.String key) {
            StringBuffer str = new StringBuffer(ISysRoleDAO.ModifyTime);
            str.append(" >= ").append(key);
            addForeignKeyCriterion(str.toString());

            return this;
        }

        public Criteria andModifyTimeGreaterThanOrEqualTo(
            BaseQueryBean subQueryBean, IDataAccessInterface<?, ?> dao) {
            addCriterion(ISysRoleDAO.ModifyTime + " >= ", subQueryBean, dao);

            return this;
        }

        public Criteria andModifyTimeLessThan(java.util.Date value) {
            addCriterionForJDBCDate(ISysRoleDAO.ModifyTime + " <", value,
                "modifyTime");

            return this;
        }

        public Criteria andModifyTimeLessThanForeignKey(java.lang.String key) {
            StringBuffer str = new StringBuffer(ISysRoleDAO.ModifyTime);
            str.append(" < ").append(key);
            addForeignKeyCriterion(str.toString());

            return this;
        }

        public Criteria andModifyTimeLessThan(BaseQueryBean subQueryBean,
            IDataAccessInterface<?, ?> dao) {
            addCriterion(ISysRoleDAO.ModifyTime + " < ", subQueryBean, dao);

            return this;
        }

        public Criteria andModifyTimeLessThanOrEqualTo(java.util.Date value) {
            addCriterionForJDBCDate(ISysRoleDAO.ModifyTime + " <=", value,
                "modifyTime");

            return this;
        }

        public Criteria andModifyTimeLessThanOrEqualToForeignKey(
            java.lang.String key) {
            StringBuffer str = new StringBuffer(ISysRoleDAO.ModifyTime);
            str.append(" <= ").append(key);
            addForeignKeyCriterion(str.toString());

            return this;
        }

        public Criteria andModifyTimeLessThanOrEqualTo(
            BaseQueryBean subQueryBean, IDataAccessInterface<?, ?> dao) {
            addCriterion(ISysRoleDAO.ModifyTime + " <= ", subQueryBean, dao);

            return this;
        }

        public Criteria andModifyTimeIn(List<java.util.Date> values) {
            if (values.size() == 1) {
                return andModifyTimeEqualTo(values.get(0));
            } else {
                addCriterionForJDBCDate(ISysRoleDAO.ModifyTime + " in", values,
                    "modifyTime");

                return this;
            }
        }

        public Criteria andModifyTimeNotIn(List<java.util.Date> values) {
            if (values.size() == 1) {
                return andModifyTimeNotEqualTo(values.get(0));
            } else {
                addCriterionForJDBCDate(ISysRoleDAO.ModifyTime + " not in",
                    values, "modifyTime");

                return this;
            }
        }

        public Criteria andModifyTimeIn(java.util.Date[] values) {
            if (values.length == 1) {
                return andModifyTimeEqualTo(values[0]);
            } else {
                addCriterionForJDBCDate(ISysRoleDAO.ModifyTime + " in",
                    Arrays.asList(values), "modifyTime");

                return this;
            }
        }

        public Criteria andModifyTimeNotIn(java.util.Date[] values) {
            if (values.length == 1) {
                return andModifyTimeNotEqualTo(values[0]);
            } else {
                addCriterionForJDBCDate(ISysRoleDAO.ModifyTime + " not in",
                    Arrays.asList(values), "modifyTime");

                return this;
            }
        }

        public Criteria andModifyTimeIn(BaseQueryBean subQueryBean,
            IDataAccessInterface<?, ?> dao) {
            addCriterion(ISysRoleDAO.ModifyTime + " in ", subQueryBean, dao);

            return this;
        }

        public Criteria andModifyTimeNotIn(BaseQueryBean subQueryBean,
            IDataAccessInterface<?, ?> dao) {
            addCriterion(ISysRoleDAO.ModifyTime + " not in ", subQueryBean, dao);

            return this;
        }

        public Criteria andModifyTimeBetween(java.util.Date value1,
            java.util.Date value2) {
            addCriterionForJDBCDate(ISysRoleDAO.ModifyTime + " between",
                value1, value2, "modifyTime");

            return this;
        }

        public Criteria andModifyTimeNotBetween(java.util.Date value1,
            java.util.Date value2) {
            addCriterionForJDBCDate(ISysRoleDAO.ModifyTime + " not between",
                value1, value2, "modifyTime");

            return this;
        }

        public Criteria andOperatorIdIsNull() {
            addCriterion(ISysRoleDAO.OperatorId + " is null");

            return this;
        }

        public Criteria andOperatorIdIsNotNull() {
            addCriterion(ISysRoleDAO.OperatorId + " is not null");

            return this;
        }

        public Criteria andOperatorIdIsNotEmpty() {
            addCriterion(ISysRoleDAO.OperatorId + " is not null AND " +
                ISysRoleDAO.OperatorId + " <> ''");

            return this;
        }

        public Criteria andOperatorIdIsEmpty() {
            addCriterion("(" + ISysRoleDAO.OperatorId + " is null OR " +
                ISysRoleDAO.OperatorId + " = '')");

            return this;
        }

        public Criteria andOperatorIdEqualTo(long value) {
            return andOperatorIdEqualTo(Long.valueOf(value));
        }

        public Criteria andOperatorIdEqualTo(java.lang.Long value) {
            addCriterion(ISysRoleDAO.OperatorId + " = ", value, "operatorId");

            return this;
        }

        public Criteria andOperatorIdEqualToForeignKey(java.lang.String key) {
            StringBuffer str = new StringBuffer(ISysRoleDAO.OperatorId);
            str.append(" = ").append(key);
            addForeignKeyCriterion(str.toString());

            return this;
        }

        public Criteria andOperatorIdEqualTo(BaseQueryBean subQueryBean,
            IDataAccessInterface<?, ?> dao) {
            addCriterion(ISysRoleDAO.OperatorId + " = ", subQueryBean, dao);

            return this;
        }

        public Criteria andOperatorIdNotEqualTo(long value) {
            return andOperatorIdNotEqualTo(Long.valueOf(value));
        }

        public Criteria andOperatorIdNotEqualTo(java.lang.Long value) {
            addCriterion(ISysRoleDAO.OperatorId + " <>", value, "operatorId");

            return this;
        }

        public Criteria andOperatorIdNotEqualToOrIsNull(long value) {
            return andOperatorIdNotEqualToOrIsNull(Long.valueOf(value));
        }

        public Criteria andOperatorIdNotEqualToOrIsNull(java.lang.Long value) {
            addCriterion(ISysRoleDAO.OperatorId + " is null OR " +
                ISysRoleDAO.OperatorId + " <>", value, "operatorId");

            return this;
        }

        public Criteria andOperatorIdNotEqualToForeignKey(java.lang.String key) {
            StringBuffer str = new StringBuffer(ISysRoleDAO.OperatorId);
            str.append(" <> ").append(key);
            addForeignKeyCriterion(str.toString());

            return this;
        }

        public Criteria andOperatorIdNotEqualTo(BaseQueryBean subQueryBean,
            IDataAccessInterface<?, ?> dao) {
            addCriterion(ISysRoleDAO.OperatorId + " <> ", subQueryBean, dao);

            return this;
        }

        public Criteria andOperatorIdGreaterThan(long value) {
            return andOperatorIdGreaterThan(Long.valueOf(value));
        }

        public Criteria andOperatorIdGreaterThan(java.lang.Long value) {
            addCriterion(ISysRoleDAO.OperatorId + " >", value, "operatorId");

            return this;
        }

        public Criteria andOperatorIdGreaterThanForeignKey(java.lang.String key) {
            StringBuffer str = new StringBuffer(ISysRoleDAO.OperatorId);
            str.append(" > ").append(key);
            addForeignKeyCriterion(str.toString());

            return this;
        }

        public Criteria andOperatorIdGreaterThan(BaseQueryBean subQueryBean,
            IDataAccessInterface<?, ?> dao) {
            addCriterion(ISysRoleDAO.OperatorId + " > ", subQueryBean, dao);

            return this;
        }

        public Criteria andOperatorIdGreaterThanOrEqualTo(long value) {
            return andOperatorIdGreaterThanOrEqualTo(Long.valueOf(value));
        }

        public Criteria andOperatorIdGreaterThanOrEqualTo(java.lang.Long value) {
            addCriterion(ISysRoleDAO.OperatorId + " >=", value, "operatorId");

            return this;
        }

        public Criteria andOperatorIdGreaterThanOrEqualToForeignKey(
            java.lang.String key) {
            StringBuffer str = new StringBuffer(ISysRoleDAO.OperatorId);
            str.append(" >= ").append(key);
            addForeignKeyCriterion(str.toString());

            return this;
        }

        public Criteria andOperatorIdGreaterThanOrEqualTo(
            BaseQueryBean subQueryBean, IDataAccessInterface<?, ?> dao) {
            addCriterion(ISysRoleDAO.OperatorId + " >= ", subQueryBean, dao);

            return this;
        }

        public Criteria andOperatorIdLessThan(long value) {
            return andOperatorIdLessThan(Long.valueOf(value));
        }

        public Criteria andOperatorIdLessThan(java.lang.Long value) {
            addCriterion(ISysRoleDAO.OperatorId + " <", value, "operatorId");

            return this;
        }

        public Criteria andOperatorIdLessThanForeignKey(java.lang.String key) {
            StringBuffer str = new StringBuffer(ISysRoleDAO.OperatorId);
            str.append(" < ").append(key);
            addForeignKeyCriterion(str.toString());

            return this;
        }

        public Criteria andOperatorIdLessThan(BaseQueryBean subQueryBean,
            IDataAccessInterface<?, ?> dao) {
            addCriterion(ISysRoleDAO.OperatorId + " < ", subQueryBean, dao);

            return this;
        }

        public Criteria andOperatorIdLessThanOrEqualTo(long value) {
            return andOperatorIdLessThanOrEqualTo(Long.valueOf(value));
        }

        public Criteria andOperatorIdLessThanOrEqualTo(java.lang.Long value) {
            addCriterion(ISysRoleDAO.OperatorId + " <=", value, "operatorId");

            return this;
        }

        public Criteria andOperatorIdLessThanOrEqualToForeignKey(
            java.lang.String key) {
            StringBuffer str = new StringBuffer(ISysRoleDAO.OperatorId);
            str.append(" <= ").append(key);
            addForeignKeyCriterion(str.toString());

            return this;
        }

        public Criteria andOperatorIdLessThanOrEqualTo(
            BaseQueryBean subQueryBean, IDataAccessInterface<?, ?> dao) {
            addCriterion(ISysRoleDAO.OperatorId + " <= ", subQueryBean, dao);

            return this;
        }

        public Criteria andOperatorIdIn(long[] values) {
            if (values.length == 1) {
                return andOperatorIdEqualTo((java.lang.Long) values[0]);
            } else {
                addCriterion(ISysRoleDAO.OperatorId + " in", values,
                    "operatorId");

                return this;
            }
        }

        public Criteria andOperatorIdNotIn(long[] values) {
            if (values.length == 1) {
                return andOperatorIdNotEqualTo((java.lang.Long) values[0]);
            } else {
                addCriterion(ISysRoleDAO.OperatorId + " not in", values,
                    "operatorId");

                return this;
            }
        }

        public Criteria andOperatorIdIn(List<java.lang.Long> values) {
            if (values.size() == 1) {
                return andOperatorIdEqualTo(values.get(0));
            } else {
                addCriterion(ISysRoleDAO.OperatorId + " in", values,
                    "operatorId");

                return this;
            }
        }

        public Criteria andOperatorIdNotIn(List<java.lang.Long> values) {
            if (values.size() == 1) {
                return andOperatorIdNotEqualTo(values.get(0));
            } else {
                addCriterion(ISysRoleDAO.OperatorId + " not in", values,
                    "operatorId");

                return this;
            }
        }

        public Criteria andOperatorIdIn(java.lang.Long[] values) {
            if (values.length == 1) {
                return andOperatorIdEqualTo(values[0]);
            } else {
                addCriterion(ISysRoleDAO.OperatorId + " in",
                    Arrays.asList(values), "operatorId");

                return this;
            }
        }

        public Criteria andOperatorIdNotIn(java.lang.Long[] values) {
            if (values.length == 1) {
                return andOperatorIdNotEqualTo(values[0]);
            } else {
                addCriterion(ISysRoleDAO.OperatorId + " not in",
                    Arrays.asList(values), "operatorId");

                return this;
            }
        }

        public Criteria andOperatorIdIn(BaseQueryBean subQueryBean,
            IDataAccessInterface<?, ?> dao) {
            addCriterion(ISysRoleDAO.OperatorId + " in ", subQueryBean, dao);

            return this;
        }

        public Criteria andOperatorIdNotIn(BaseQueryBean subQueryBean,
            IDataAccessInterface<?, ?> dao) {
            addCriterion(ISysRoleDAO.OperatorId + " not in ", subQueryBean, dao);

            return this;
        }

        public Criteria andOperatorIdBetween(long value1, long value2) {
            addCriterion(ISysRoleDAO.OperatorId + " between", value1, value2,
                "operatorId");

            return this;
        }

        public Criteria andOperatorIdBetween(java.lang.Long value1,
            java.lang.Long value2) {
            addCriterion(ISysRoleDAO.OperatorId + " between", value1, value2,
                "operatorId");

            return this;
        }

        public Criteria andOperatorIdNotBetween(long value1, long value2) {
            addCriterion(ISysRoleDAO.OperatorId + " not between", value1,
                value2, "operatorId");

            return this;
        }

        public Criteria andOperatorIdNotBetween(java.lang.Long value1,
            java.lang.Long value2) {
            addCriterion(ISysRoleDAO.OperatorId + " not between", value1,
                value2, "operatorId");

            return this;
        }

        public Criteria andOperatorNameIsNull() {
            addCriterion(ISysRoleDAO.OperatorName + " is null");

            return this;
        }

        public Criteria andOperatorNameIsNotNull() {
            addCriterion(ISysRoleDAO.OperatorName + " is not null");

            return this;
        }

        public Criteria andOperatorNameIsNotEmpty() {
            addCriterion(ISysRoleDAO.OperatorName + " is not null AND " +
                ISysRoleDAO.OperatorName + " <> ''");

            return this;
        }

        public Criteria andOperatorNameIsEmpty() {
            addCriterion("(" + ISysRoleDAO.OperatorName + " is null OR " +
                ISysRoleDAO.OperatorName + " = '')");

            return this;
        }

        public Criteria andOperatorNameEqualTo(String value) {
            addCriterion(ISysRoleDAO.OperatorName + " = ", value, "operatorName");

            return this;
        }

        public Criteria andOperatorNameEqualToForeignKey(java.lang.String key) {
            StringBuffer str = new StringBuffer(ISysRoleDAO.OperatorName);
            str.append(" = ").append(key);
            addForeignKeyCriterion(str.toString());

            return this;
        }

        public Criteria andOperatorNameEqualTo(BaseQueryBean subQueryBean,
            IDataAccessInterface<?, ?> dao) {
            addCriterion(ISysRoleDAO.OperatorName + " = ", subQueryBean, dao);

            return this;
        }

        public Criteria andOperatorNameNotEqualTo(String value) {
            addCriterion(ISysRoleDAO.OperatorName + " <>", value, "operatorName");

            return this;
        }

        public Criteria andOperatorNameNotEqualToOrIsNull(String value) {
            addCriterion(ISysRoleDAO.OperatorName + " is null OR " +
                ISysRoleDAO.OperatorName + " <>", value, "operatorName");

            return this;
        }

        public Criteria andOperatorNameNotEqualToForeignKey(
            java.lang.String key) {
            StringBuffer str = new StringBuffer(ISysRoleDAO.OperatorName);
            str.append(" <> ").append(key);
            addForeignKeyCriterion(str.toString());

            return this;
        }

        public Criteria andOperatorNameNotEqualTo(BaseQueryBean subQueryBean,
            IDataAccessInterface<?, ?> dao) {
            addCriterion(ISysRoleDAO.OperatorName + " <> ", subQueryBean, dao);

            return this;
        }

        public Criteria andOperatorNameGreaterThan(String value) {
            addCriterion(ISysRoleDAO.OperatorName + " >", value, "operatorName");

            return this;
        }

        public Criteria andOperatorNameGreaterThanForeignKey(
            java.lang.String key) {
            StringBuffer str = new StringBuffer(ISysRoleDAO.OperatorName);
            str.append(" > ").append(key);
            addForeignKeyCriterion(str.toString());

            return this;
        }

        public Criteria andOperatorNameGreaterThan(BaseQueryBean subQueryBean,
            IDataAccessInterface<?, ?> dao) {
            addCriterion(ISysRoleDAO.OperatorName + " > ", subQueryBean, dao);

            return this;
        }

        public Criteria andOperatorNameGreaterThanOrEqualTo(String value) {
            addCriterion(ISysRoleDAO.OperatorName + " >=", value, "operatorName");

            return this;
        }

        public Criteria andOperatorNameGreaterThanOrEqualToForeignKey(
            java.lang.String key) {
            StringBuffer str = new StringBuffer(ISysRoleDAO.OperatorName);
            str.append(" >= ").append(key);
            addForeignKeyCriterion(str.toString());

            return this;
        }

        public Criteria andOperatorNameGreaterThanOrEqualTo(
            BaseQueryBean subQueryBean, IDataAccessInterface<?, ?> dao) {
            addCriterion(ISysRoleDAO.OperatorName + " >= ", subQueryBean, dao);

            return this;
        }

        public Criteria andOperatorNameLessThan(String value) {
            addCriterion(ISysRoleDAO.OperatorName + " <", value, "operatorName");

            return this;
        }

        public Criteria andOperatorNameLessThanForeignKey(java.lang.String key) {
            StringBuffer str = new StringBuffer(ISysRoleDAO.OperatorName);
            str.append(" < ").append(key);
            addForeignKeyCriterion(str.toString());

            return this;
        }

        public Criteria andOperatorNameLessThan(BaseQueryBean subQueryBean,
            IDataAccessInterface<?, ?> dao) {
            addCriterion(ISysRoleDAO.OperatorName + " < ", subQueryBean, dao);

            return this;
        }

        public Criteria andOperatorNameLessThanOrEqualTo(String value) {
            addCriterion(ISysRoleDAO.OperatorName + " <=", value, "operatorName");

            return this;
        }

        public Criteria andOperatorNameLessThanOrEqualToForeignKey(
            java.lang.String key) {
            StringBuffer str = new StringBuffer(ISysRoleDAO.OperatorName);
            str.append(" <= ").append(key);
            addForeignKeyCriterion(str.toString());

            return this;
        }

        public Criteria andOperatorNameLessThanOrEqualTo(
            BaseQueryBean subQueryBean, IDataAccessInterface<?, ?> dao) {
            addCriterion(ISysRoleDAO.OperatorName + " <= ", subQueryBean, dao);

            return this;
        }

        public Criteria andOperatorNameLike(String value) {
            StringBuffer buffer = new StringBuffer("%");
            buffer.append(value);
            buffer.append("%");
            addCriterion(ISysRoleDAO.OperatorName + " like", buffer.toString(),
                "operatorName");

            return this;
        }

        public Criteria andOperatorNameNotLike(String value) {
            StringBuffer buffer = new StringBuffer("%");
            buffer.append(value);
            buffer.append("%");
            addCriterion(ISysRoleDAO.OperatorName + " not like",
                buffer.toString(), "operatorName");

            return this;
        }

        public Criteria andOperatorNameIn(List<String> values) {
            if (values.size() == 1) {
                return andOperatorNameEqualTo(values.get(0));
            } else {
                addCriterion(ISysRoleDAO.OperatorName + " in", values,
                    "operatorName");

                return this;
            }
        }

        public Criteria andOperatorNameNotIn(List<String> values) {
            if (values.size() == 1) {
                return andOperatorNameNotEqualTo(values.get(0));
            } else {
                addCriterion(ISysRoleDAO.OperatorName + " not in", values,
                    "operatorName");

                return this;
            }
        }

        public Criteria andOperatorNameIn(String[] values) {
            if (values.length == 1) {
                return andOperatorNameEqualTo(values[0]);
            } else {
                addCriterion(ISysRoleDAO.OperatorName + " in",
                    Arrays.asList(values), "operatorName");

                return this;
            }
        }

        public Criteria andOperatorNameNotIn(String[] values) {
            if (values.length == 1) {
                return andOperatorNameNotEqualTo(values[0]);
            } else {
                addCriterion(ISysRoleDAO.OperatorName + " not in",
                    Arrays.asList(values), "operatorName");

                return this;
            }
        }

        public Criteria andOperatorNameIn(BaseQueryBean subQueryBean,
            IDataAccessInterface<?, ?> dao) {
            addCriterion(ISysRoleDAO.OperatorName + " in ", subQueryBean, dao);

            return this;
        }

        public Criteria andOperatorNameNotIn(BaseQueryBean subQueryBean,
            IDataAccessInterface<?, ?> dao) {
            addCriterion(ISysRoleDAO.OperatorName + " not in ", subQueryBean,
                dao);

            return this;
        }

        public Criteria andOperatorNameBetween(String value1, String value2) {
            addCriterion(ISysRoleDAO.OperatorName + " between", value1, value2,
                "operatorName");

            return this;
        }

        public Criteria andOperatorNameNotBetween(String value1, String value2) {
            addCriterion(ISysRoleDAO.OperatorName + " not between", value1,
                value2, "operatorName");

            return this;
        }

        public Criteria andDomainTitleKeyIsNull() {
            addCriterion(ISysRoleDAO.DomainTitleKey + " is null");

            return this;
        }

        public Criteria andDomainTitleKeyIsNotNull() {
            addCriterion(ISysRoleDAO.DomainTitleKey + " is not null");

            return this;
        }

        public Criteria andDomainTitleKeyIsNotEmpty() {
            addCriterion(ISysRoleDAO.DomainTitleKey + " is not null AND " +
                ISysRoleDAO.DomainTitleKey + " <> ''");

            return this;
        }

        public Criteria andDomainTitleKeyIsEmpty() {
            addCriterion("(" + ISysRoleDAO.DomainTitleKey + " is null OR " +
                ISysRoleDAO.DomainTitleKey + " = '')");

            return this;
        }

        public Criteria andDomainTitleKeyEqualTo(String value) {
            addCriterion(ISysRoleDAO.DomainTitleKey + " = ", value,
                "domainTitleKey");

            return this;
        }

        public Criteria andDomainTitleKeyEqualToForeignKey(java.lang.String key) {
            StringBuffer str = new StringBuffer(ISysRoleDAO.DomainTitleKey);
            str.append(" = ").append(key);
            addForeignKeyCriterion(str.toString());

            return this;
        }

        public Criteria andDomainTitleKeyEqualTo(BaseQueryBean subQueryBean,
            IDataAccessInterface<?, ?> dao) {
            addCriterion(ISysRoleDAO.DomainTitleKey + " = ", subQueryBean, dao);

            return this;
        }

        public Criteria andDomainTitleKeyNotEqualTo(String value) {
            addCriterion(ISysRoleDAO.DomainTitleKey + " <>", value,
                "domainTitleKey");

            return this;
        }

        public Criteria andDomainTitleKeyNotEqualToOrIsNull(String value) {
            addCriterion(ISysRoleDAO.DomainTitleKey + " is null OR " +
                ISysRoleDAO.DomainTitleKey + " <>", value, "domainTitleKey");

            return this;
        }

        public Criteria andDomainTitleKeyNotEqualToForeignKey(
            java.lang.String key) {
            StringBuffer str = new StringBuffer(ISysRoleDAO.DomainTitleKey);
            str.append(" <> ").append(key);
            addForeignKeyCriterion(str.toString());

            return this;
        }

        public Criteria andDomainTitleKeyNotEqualTo(
            BaseQueryBean subQueryBean, IDataAccessInterface<?, ?> dao) {
            addCriterion(ISysRoleDAO.DomainTitleKey + " <> ", subQueryBean, dao);

            return this;
        }

        public Criteria andDomainTitleKeyGreaterThan(String value) {
            addCriterion(ISysRoleDAO.DomainTitleKey + " >", value,
                "domainTitleKey");

            return this;
        }

        public Criteria andDomainTitleKeyGreaterThanForeignKey(
            java.lang.String key) {
            StringBuffer str = new StringBuffer(ISysRoleDAO.DomainTitleKey);
            str.append(" > ").append(key);
            addForeignKeyCriterion(str.toString());

            return this;
        }

        public Criteria andDomainTitleKeyGreaterThan(
            BaseQueryBean subQueryBean, IDataAccessInterface<?, ?> dao) {
            addCriterion(ISysRoleDAO.DomainTitleKey + " > ", subQueryBean, dao);

            return this;
        }

        public Criteria andDomainTitleKeyGreaterThanOrEqualTo(String value) {
            addCriterion(ISysRoleDAO.DomainTitleKey + " >=", value,
                "domainTitleKey");

            return this;
        }

        public Criteria andDomainTitleKeyGreaterThanOrEqualToForeignKey(
            java.lang.String key) {
            StringBuffer str = new StringBuffer(ISysRoleDAO.DomainTitleKey);
            str.append(" >= ").append(key);
            addForeignKeyCriterion(str.toString());

            return this;
        }

        public Criteria andDomainTitleKeyGreaterThanOrEqualTo(
            BaseQueryBean subQueryBean, IDataAccessInterface<?, ?> dao) {
            addCriterion(ISysRoleDAO.DomainTitleKey + " >= ", subQueryBean, dao);

            return this;
        }

        public Criteria andDomainTitleKeyLessThan(String value) {
            addCriterion(ISysRoleDAO.DomainTitleKey + " <", value,
                "domainTitleKey");

            return this;
        }

        public Criteria andDomainTitleKeyLessThanForeignKey(
            java.lang.String key) {
            StringBuffer str = new StringBuffer(ISysRoleDAO.DomainTitleKey);
            str.append(" < ").append(key);
            addForeignKeyCriterion(str.toString());

            return this;
        }

        public Criteria andDomainTitleKeyLessThan(BaseQueryBean subQueryBean,
            IDataAccessInterface<?, ?> dao) {
            addCriterion(ISysRoleDAO.DomainTitleKey + " < ", subQueryBean, dao);

            return this;
        }

        public Criteria andDomainTitleKeyLessThanOrEqualTo(String value) {
            addCriterion(ISysRoleDAO.DomainTitleKey + " <=", value,
                "domainTitleKey");

            return this;
        }

        public Criteria andDomainTitleKeyLessThanOrEqualToForeignKey(
            java.lang.String key) {
            StringBuffer str = new StringBuffer(ISysRoleDAO.DomainTitleKey);
            str.append(" <= ").append(key);
            addForeignKeyCriterion(str.toString());

            return this;
        }

        public Criteria andDomainTitleKeyLessThanOrEqualTo(
            BaseQueryBean subQueryBean, IDataAccessInterface<?, ?> dao) {
            addCriterion(ISysRoleDAO.DomainTitleKey + " <= ", subQueryBean, dao);

            return this;
        }

        public Criteria andDomainTitleKeyLike(String value) {
            StringBuffer buffer = new StringBuffer("%");
            buffer.append(value);
            buffer.append("%");
            addCriterion(ISysRoleDAO.DomainTitleKey + " like",
                buffer.toString(), "domainTitleKey");

            return this;
        }

        public Criteria andDomainTitleKeyNotLike(String value) {
            StringBuffer buffer = new StringBuffer("%");
            buffer.append(value);
            buffer.append("%");
            addCriterion(ISysRoleDAO.DomainTitleKey + " not like",
                buffer.toString(), "domainTitleKey");

            return this;
        }

        public Criteria andDomainTitleKeyIn(List<String> values) {
            if (values.size() == 1) {
                return andDomainTitleKeyEqualTo(values.get(0));
            } else {
                addCriterion(ISysRoleDAO.DomainTitleKey + " in", values,
                    "domainTitleKey");

                return this;
            }
        }

        public Criteria andDomainTitleKeyNotIn(List<String> values) {
            if (values.size() == 1) {
                return andDomainTitleKeyNotEqualTo(values.get(0));
            } else {
                addCriterion(ISysRoleDAO.DomainTitleKey + " not in", values,
                    "domainTitleKey");

                return this;
            }
        }

        public Criteria andDomainTitleKeyIn(String[] values) {
            if (values.length == 1) {
                return andDomainTitleKeyEqualTo(values[0]);
            } else {
                addCriterion(ISysRoleDAO.DomainTitleKey + " in",
                    Arrays.asList(values), "domainTitleKey");

                return this;
            }
        }

        public Criteria andDomainTitleKeyNotIn(String[] values) {
            if (values.length == 1) {
                return andDomainTitleKeyNotEqualTo(values[0]);
            } else {
                addCriterion(ISysRoleDAO.DomainTitleKey + " not in",
                    Arrays.asList(values), "domainTitleKey");

                return this;
            }
        }

        public Criteria andDomainTitleKeyIn(BaseQueryBean subQueryBean,
            IDataAccessInterface<?, ?> dao) {
            addCriterion(ISysRoleDAO.DomainTitleKey + " in ", subQueryBean, dao);

            return this;
        }

        public Criteria andDomainTitleKeyNotIn(BaseQueryBean subQueryBean,
            IDataAccessInterface<?, ?> dao) {
            addCriterion(ISysRoleDAO.DomainTitleKey + " not in ", subQueryBean,
                dao);

            return this;
        }

        public Criteria andDomainTitleKeyBetween(String value1, String value2) {
            addCriterion(ISysRoleDAO.DomainTitleKey + " between", value1,
                value2, "domainTitleKey");

            return this;
        }

        public Criteria andDomainTitleKeyNotBetween(String value1, String value2) {
            addCriterion(ISysRoleDAO.DomainTitleKey + " not between", value1,
                value2, "domainTitleKey");

            return this;
        }

        public Criteria andDomainNameIsNull() {
            addCriterion(ISysRoleDAO.DomainName + " is null");

            return this;
        }

        public Criteria andDomainNameIsNotNull() {
            addCriterion(ISysRoleDAO.DomainName + " is not null");

            return this;
        }

        public Criteria andDomainNameIsNotEmpty() {
            addCriterion(ISysRoleDAO.DomainName + " is not null AND " +
                ISysRoleDAO.DomainName + " <> ''");

            return this;
        }

        public Criteria andDomainNameIsEmpty() {
            addCriterion("(" + ISysRoleDAO.DomainName + " is null OR " +
                ISysRoleDAO.DomainName + " = '')");

            return this;
        }

        public Criteria andDomainNameEqualTo(String value) {
            addCriterion(ISysRoleDAO.DomainName + " = ", value, "domainName");

            return this;
        }

        public Criteria andDomainNameEqualToForeignKey(java.lang.String key) {
            StringBuffer str = new StringBuffer(ISysRoleDAO.DomainName);
            str.append(" = ").append(key);
            addForeignKeyCriterion(str.toString());

            return this;
        }

        public Criteria andDomainNameEqualTo(BaseQueryBean subQueryBean,
            IDataAccessInterface<?, ?> dao) {
            addCriterion(ISysRoleDAO.DomainName + " = ", subQueryBean, dao);

            return this;
        }

        public Criteria andDomainNameNotEqualTo(String value) {
            addCriterion(ISysRoleDAO.DomainName + " <>", value, "domainName");

            return this;
        }

        public Criteria andDomainNameNotEqualToOrIsNull(String value) {
            addCriterion(ISysRoleDAO.DomainName + " is null OR " +
                ISysRoleDAO.DomainName + " <>", value, "domainName");

            return this;
        }

        public Criteria andDomainNameNotEqualToForeignKey(java.lang.String key) {
            StringBuffer str = new StringBuffer(ISysRoleDAO.DomainName);
            str.append(" <> ").append(key);
            addForeignKeyCriterion(str.toString());

            return this;
        }

        public Criteria andDomainNameNotEqualTo(BaseQueryBean subQueryBean,
            IDataAccessInterface<?, ?> dao) {
            addCriterion(ISysRoleDAO.DomainName + " <> ", subQueryBean, dao);

            return this;
        }

        public Criteria andDomainNameGreaterThan(String value) {
            addCriterion(ISysRoleDAO.DomainName + " >", value, "domainName");

            return this;
        }

        public Criteria andDomainNameGreaterThanForeignKey(java.lang.String key) {
            StringBuffer str = new StringBuffer(ISysRoleDAO.DomainName);
            str.append(" > ").append(key);
            addForeignKeyCriterion(str.toString());

            return this;
        }

        public Criteria andDomainNameGreaterThan(BaseQueryBean subQueryBean,
            IDataAccessInterface<?, ?> dao) {
            addCriterion(ISysRoleDAO.DomainName + " > ", subQueryBean, dao);

            return this;
        }

        public Criteria andDomainNameGreaterThanOrEqualTo(String value) {
            addCriterion(ISysRoleDAO.DomainName + " >=", value, "domainName");

            return this;
        }

        public Criteria andDomainNameGreaterThanOrEqualToForeignKey(
            java.lang.String key) {
            StringBuffer str = new StringBuffer(ISysRoleDAO.DomainName);
            str.append(" >= ").append(key);
            addForeignKeyCriterion(str.toString());

            return this;
        }

        public Criteria andDomainNameGreaterThanOrEqualTo(
            BaseQueryBean subQueryBean, IDataAccessInterface<?, ?> dao) {
            addCriterion(ISysRoleDAO.DomainName + " >= ", subQueryBean, dao);

            return this;
        }

        public Criteria andDomainNameLessThan(String value) {
            addCriterion(ISysRoleDAO.DomainName + " <", value, "domainName");

            return this;
        }

        public Criteria andDomainNameLessThanForeignKey(java.lang.String key) {
            StringBuffer str = new StringBuffer(ISysRoleDAO.DomainName);
            str.append(" < ").append(key);
            addForeignKeyCriterion(str.toString());

            return this;
        }

        public Criteria andDomainNameLessThan(BaseQueryBean subQueryBean,
            IDataAccessInterface<?, ?> dao) {
            addCriterion(ISysRoleDAO.DomainName + " < ", subQueryBean, dao);

            return this;
        }

        public Criteria andDomainNameLessThanOrEqualTo(String value) {
            addCriterion(ISysRoleDAO.DomainName + " <=", value, "domainName");

            return this;
        }

        public Criteria andDomainNameLessThanOrEqualToForeignKey(
            java.lang.String key) {
            StringBuffer str = new StringBuffer(ISysRoleDAO.DomainName);
            str.append(" <= ").append(key);
            addForeignKeyCriterion(str.toString());

            return this;
        }

        public Criteria andDomainNameLessThanOrEqualTo(
            BaseQueryBean subQueryBean, IDataAccessInterface<?, ?> dao) {
            addCriterion(ISysRoleDAO.DomainName + " <= ", subQueryBean, dao);

            return this;
        }

        public Criteria andDomainNameLike(String value) {
            StringBuffer buffer = new StringBuffer("%");
            buffer.append(value);
            buffer.append("%");
            addCriterion(ISysRoleDAO.DomainName + " like", buffer.toString(),
                "domainName");

            return this;
        }

        public Criteria andDomainNameNotLike(String value) {
            StringBuffer buffer = new StringBuffer("%");
            buffer.append(value);
            buffer.append("%");
            addCriterion(ISysRoleDAO.DomainName + " not like",
                buffer.toString(), "domainName");

            return this;
        }

        public Criteria andDomainNameIn(List<String> values) {
            if (values.size() == 1) {
                return andDomainNameEqualTo(values.get(0));
            } else {
                addCriterion(ISysRoleDAO.DomainName + " in", values,
                    "domainName");

                return this;
            }
        }

        public Criteria andDomainNameNotIn(List<String> values) {
            if (values.size() == 1) {
                return andDomainNameNotEqualTo(values.get(0));
            } else {
                addCriterion(ISysRoleDAO.DomainName + " not in", values,
                    "domainName");

                return this;
            }
        }

        public Criteria andDomainNameIn(String[] values) {
            if (values.length == 1) {
                return andDomainNameEqualTo(values[0]);
            } else {
                addCriterion(ISysRoleDAO.DomainName + " in",
                    Arrays.asList(values), "domainName");

                return this;
            }
        }

        public Criteria andDomainNameNotIn(String[] values) {
            if (values.length == 1) {
                return andDomainNameNotEqualTo(values[0]);
            } else {
                addCriterion(ISysRoleDAO.DomainName + " not in",
                    Arrays.asList(values), "domainName");

                return this;
            }
        }

        public Criteria andDomainNameIn(BaseQueryBean subQueryBean,
            IDataAccessInterface<?, ?> dao) {
            addCriterion(ISysRoleDAO.DomainName + " in ", subQueryBean, dao);

            return this;
        }

        public Criteria andDomainNameNotIn(BaseQueryBean subQueryBean,
            IDataAccessInterface<?, ?> dao) {
            addCriterion(ISysRoleDAO.DomainName + " not in ", subQueryBean, dao);

            return this;
        }

        public Criteria andDomainNameBetween(String value1, String value2) {
            addCriterion(ISysRoleDAO.DomainName + " between", value1, value2,
                "domainName");

            return this;
        }

        public Criteria andDomainNameNotBetween(String value1, String value2) {
            addCriterion(ISysRoleDAO.DomainName + " not between", value1,
                value2, "domainName");

            return this;
        }

        public Criteria andDomainCodeIsNull() {
            addCriterion(ISysRoleDAO.DomainCode + " is null");

            return this;
        }

        public Criteria andDomainCodeIsNotNull() {
            addCriterion(ISysRoleDAO.DomainCode + " is not null");

            return this;
        }

        public Criteria andDomainCodeIsNotEmpty() {
            addCriterion(ISysRoleDAO.DomainCode + " is not null AND " +
                ISysRoleDAO.DomainCode + " <> ''");

            return this;
        }

        public Criteria andDomainCodeIsEmpty() {
            addCriterion("(" + ISysRoleDAO.DomainCode + " is null OR " +
                ISysRoleDAO.DomainCode + " = '')");

            return this;
        }

        public Criteria andDomainCodeEqualTo(String value) {
            addCriterion(ISysRoleDAO.DomainCode + " = ", value, "domainCode");

            return this;
        }

        public Criteria andDomainCodeEqualToForeignKey(java.lang.String key) {
            StringBuffer str = new StringBuffer(ISysRoleDAO.DomainCode);
            str.append(" = ").append(key);
            addForeignKeyCriterion(str.toString());

            return this;
        }

        public Criteria andDomainCodeEqualTo(BaseQueryBean subQueryBean,
            IDataAccessInterface<?, ?> dao) {
            addCriterion(ISysRoleDAO.DomainCode + " = ", subQueryBean, dao);

            return this;
        }

        public Criteria andDomainCodeNotEqualTo(String value) {
            addCriterion(ISysRoleDAO.DomainCode + " <>", value, "domainCode");

            return this;
        }

        public Criteria andDomainCodeNotEqualToOrIsNull(String value) {
            addCriterion(ISysRoleDAO.DomainCode + " is null OR " +
                ISysRoleDAO.DomainCode + " <>", value, "domainCode");

            return this;
        }

        public Criteria andDomainCodeNotEqualToForeignKey(java.lang.String key) {
            StringBuffer str = new StringBuffer(ISysRoleDAO.DomainCode);
            str.append(" <> ").append(key);
            addForeignKeyCriterion(str.toString());

            return this;
        }

        public Criteria andDomainCodeNotEqualTo(BaseQueryBean subQueryBean,
            IDataAccessInterface<?, ?> dao) {
            addCriterion(ISysRoleDAO.DomainCode + " <> ", subQueryBean, dao);

            return this;
        }

        public Criteria andDomainCodeGreaterThan(String value) {
            addCriterion(ISysRoleDAO.DomainCode + " >", value, "domainCode");

            return this;
        }

        public Criteria andDomainCodeGreaterThanForeignKey(java.lang.String key) {
            StringBuffer str = new StringBuffer(ISysRoleDAO.DomainCode);
            str.append(" > ").append(key);
            addForeignKeyCriterion(str.toString());

            return this;
        }

        public Criteria andDomainCodeGreaterThan(BaseQueryBean subQueryBean,
            IDataAccessInterface<?, ?> dao) {
            addCriterion(ISysRoleDAO.DomainCode + " > ", subQueryBean, dao);

            return this;
        }

        public Criteria andDomainCodeGreaterThanOrEqualTo(String value) {
            addCriterion(ISysRoleDAO.DomainCode + " >=", value, "domainCode");

            return this;
        }

        public Criteria andDomainCodeGreaterThanOrEqualToForeignKey(
            java.lang.String key) {
            StringBuffer str = new StringBuffer(ISysRoleDAO.DomainCode);
            str.append(" >= ").append(key);
            addForeignKeyCriterion(str.toString());

            return this;
        }

        public Criteria andDomainCodeGreaterThanOrEqualTo(
            BaseQueryBean subQueryBean, IDataAccessInterface<?, ?> dao) {
            addCriterion(ISysRoleDAO.DomainCode + " >= ", subQueryBean, dao);

            return this;
        }

        public Criteria andDomainCodeLessThan(String value) {
            addCriterion(ISysRoleDAO.DomainCode + " <", value, "domainCode");

            return this;
        }

        public Criteria andDomainCodeLessThanForeignKey(java.lang.String key) {
            StringBuffer str = new StringBuffer(ISysRoleDAO.DomainCode);
            str.append(" < ").append(key);
            addForeignKeyCriterion(str.toString());

            return this;
        }

        public Criteria andDomainCodeLessThan(BaseQueryBean subQueryBean,
            IDataAccessInterface<?, ?> dao) {
            addCriterion(ISysRoleDAO.DomainCode + " < ", subQueryBean, dao);

            return this;
        }

        public Criteria andDomainCodeLessThanOrEqualTo(String value) {
            addCriterion(ISysRoleDAO.DomainCode + " <=", value, "domainCode");

            return this;
        }

        public Criteria andDomainCodeLessThanOrEqualToForeignKey(
            java.lang.String key) {
            StringBuffer str = new StringBuffer(ISysRoleDAO.DomainCode);
            str.append(" <= ").append(key);
            addForeignKeyCriterion(str.toString());

            return this;
        }

        public Criteria andDomainCodeLessThanOrEqualTo(
            BaseQueryBean subQueryBean, IDataAccessInterface<?, ?> dao) {
            addCriterion(ISysRoleDAO.DomainCode + " <= ", subQueryBean, dao);

            return this;
        }

        public Criteria andDomainCodeLike(String value) {
            StringBuffer buffer = new StringBuffer("%");
            buffer.append(value);
            buffer.append("%");
            addCriterion(ISysRoleDAO.DomainCode + " like", buffer.toString(),
                "domainCode");

            return this;
        }

        public Criteria andDomainCodeNotLike(String value) {
            StringBuffer buffer = new StringBuffer("%");
            buffer.append(value);
            buffer.append("%");
            addCriterion(ISysRoleDAO.DomainCode + " not like",
                buffer.toString(), "domainCode");

            return this;
        }

        public Criteria andDomainCodeIn(List<String> values) {
            if (values.size() == 1) {
                return andDomainCodeEqualTo(values.get(0));
            } else {
                addCriterion(ISysRoleDAO.DomainCode + " in", values,
                    "domainCode");

                return this;
            }
        }

        public Criteria andDomainCodeNotIn(List<String> values) {
            if (values.size() == 1) {
                return andDomainCodeNotEqualTo(values.get(0));
            } else {
                addCriterion(ISysRoleDAO.DomainCode + " not in", values,
                    "domainCode");

                return this;
            }
        }

        public Criteria andDomainCodeIn(String[] values) {
            if (values.length == 1) {
                return andDomainCodeEqualTo(values[0]);
            } else {
                addCriterion(ISysRoleDAO.DomainCode + " in",
                    Arrays.asList(values), "domainCode");

                return this;
            }
        }

        public Criteria andDomainCodeNotIn(String[] values) {
            if (values.length == 1) {
                return andDomainCodeNotEqualTo(values[0]);
            } else {
                addCriterion(ISysRoleDAO.DomainCode + " not in",
                    Arrays.asList(values), "domainCode");

                return this;
            }
        }

        public Criteria andDomainCodeIn(BaseQueryBean subQueryBean,
            IDataAccessInterface<?, ?> dao) {
            addCriterion(ISysRoleDAO.DomainCode + " in ", subQueryBean, dao);

            return this;
        }

        public Criteria andDomainCodeNotIn(BaseQueryBean subQueryBean,
            IDataAccessInterface<?, ?> dao) {
            addCriterion(ISysRoleDAO.DomainCode + " not in ", subQueryBean, dao);

            return this;
        }

        public Criteria andDomainCodeBetween(String value1, String value2) {
            addCriterion(ISysRoleDAO.DomainCode + " between", value1, value2,
                "domainCode");

            return this;
        }

        public Criteria andDomainCodeNotBetween(String value1, String value2) {
            addCriterion(ISysRoleDAO.DomainCode + " not between", value1,
                value2, "domainCode");

            return this;
        }

        public Criteria andDomainSortIndexIsNull() {
            addCriterion(ISysRoleDAO.DomainSortIndex + " is null");

            return this;
        }

        public Criteria andDomainSortIndexIsNotNull() {
            addCriterion(ISysRoleDAO.DomainSortIndex + " is not null");

            return this;
        }

        public Criteria andDomainSortIndexIsNotEmpty() {
            addCriterion(ISysRoleDAO.DomainSortIndex + " is not null AND " +
                ISysRoleDAO.DomainSortIndex + " <> ''");

            return this;
        }

        public Criteria andDomainSortIndexIsEmpty() {
            addCriterion("(" + ISysRoleDAO.DomainSortIndex + " is null OR " +
                ISysRoleDAO.DomainSortIndex + " = '')");

            return this;
        }

        public Criteria andDomainSortIndexEqualTo(int value) {
            return andDomainSortIndexEqualTo(Integer.valueOf(value));
        }

        public Criteria andDomainSortIndexEqualTo(java.lang.Integer value) {
            addCriterion(ISysRoleDAO.DomainSortIndex + " = ", value,
                "domainSortIndex");

            return this;
        }

        public Criteria andDomainSortIndexEqualToForeignKey(
            java.lang.String key) {
            StringBuffer str = new StringBuffer(ISysRoleDAO.DomainSortIndex);
            str.append(" = ").append(key);
            addForeignKeyCriterion(str.toString());

            return this;
        }

        public Criteria andDomainSortIndexEqualTo(BaseQueryBean subQueryBean,
            IDataAccessInterface<?, ?> dao) {
            addCriterion(ISysRoleDAO.DomainSortIndex + " = ", subQueryBean, dao);

            return this;
        }

        public Criteria andDomainSortIndexNotEqualTo(int value) {
            return andDomainSortIndexNotEqualTo(Integer.valueOf(value));
        }

        public Criteria andDomainSortIndexNotEqualTo(java.lang.Integer value) {
            addCriterion(ISysRoleDAO.DomainSortIndex + " <>", value,
                "domainSortIndex");

            return this;
        }

        public Criteria andDomainSortIndexNotEqualToOrIsNull(int value) {
            return andDomainSortIndexNotEqualToOrIsNull(Integer.valueOf(value));
        }

        public Criteria andDomainSortIndexNotEqualToOrIsNull(
            java.lang.Integer value) {
            addCriterion(ISysRoleDAO.DomainSortIndex + " is null OR " +
                ISysRoleDAO.DomainSortIndex + " <>", value, "domainSortIndex");

            return this;
        }

        public Criteria andDomainSortIndexNotEqualToForeignKey(
            java.lang.String key) {
            StringBuffer str = new StringBuffer(ISysRoleDAO.DomainSortIndex);
            str.append(" <> ").append(key);
            addForeignKeyCriterion(str.toString());

            return this;
        }

        public Criteria andDomainSortIndexNotEqualTo(
            BaseQueryBean subQueryBean, IDataAccessInterface<?, ?> dao) {
            addCriterion(ISysRoleDAO.DomainSortIndex + " <> ", subQueryBean, dao);

            return this;
        }

        public Criteria andDomainSortIndexGreaterThan(int value) {
            return andDomainSortIndexGreaterThan(Integer.valueOf(value));
        }

        public Criteria andDomainSortIndexGreaterThan(java.lang.Integer value) {
            addCriterion(ISysRoleDAO.DomainSortIndex + " >", value,
                "domainSortIndex");

            return this;
        }

        public Criteria andDomainSortIndexGreaterThanForeignKey(
            java.lang.String key) {
            StringBuffer str = new StringBuffer(ISysRoleDAO.DomainSortIndex);
            str.append(" > ").append(key);
            addForeignKeyCriterion(str.toString());

            return this;
        }

        public Criteria andDomainSortIndexGreaterThan(
            BaseQueryBean subQueryBean, IDataAccessInterface<?, ?> dao) {
            addCriterion(ISysRoleDAO.DomainSortIndex + " > ", subQueryBean, dao);

            return this;
        }

        public Criteria andDomainSortIndexGreaterThanOrEqualTo(int value) {
            return andDomainSortIndexGreaterThanOrEqualTo(Integer.valueOf(value));
        }

        public Criteria andDomainSortIndexGreaterThanOrEqualTo(
            java.lang.Integer value) {
            addCriterion(ISysRoleDAO.DomainSortIndex + " >=", value,
                "domainSortIndex");

            return this;
        }

        public Criteria andDomainSortIndexGreaterThanOrEqualToForeignKey(
            java.lang.String key) {
            StringBuffer str = new StringBuffer(ISysRoleDAO.DomainSortIndex);
            str.append(" >= ").append(key);
            addForeignKeyCriterion(str.toString());

            return this;
        }

        public Criteria andDomainSortIndexGreaterThanOrEqualTo(
            BaseQueryBean subQueryBean, IDataAccessInterface<?, ?> dao) {
            addCriterion(ISysRoleDAO.DomainSortIndex + " >= ", subQueryBean, dao);

            return this;
        }

        public Criteria andDomainSortIndexLessThan(int value) {
            return andDomainSortIndexLessThan(Integer.valueOf(value));
        }

        public Criteria andDomainSortIndexLessThan(java.lang.Integer value) {
            addCriterion(ISysRoleDAO.DomainSortIndex + " <", value,
                "domainSortIndex");

            return this;
        }

        public Criteria andDomainSortIndexLessThanForeignKey(
            java.lang.String key) {
            StringBuffer str = new StringBuffer(ISysRoleDAO.DomainSortIndex);
            str.append(" < ").append(key);
            addForeignKeyCriterion(str.toString());

            return this;
        }

        public Criteria andDomainSortIndexLessThan(BaseQueryBean subQueryBean,
            IDataAccessInterface<?, ?> dao) {
            addCriterion(ISysRoleDAO.DomainSortIndex + " < ", subQueryBean, dao);

            return this;
        }

        public Criteria andDomainSortIndexLessThanOrEqualTo(int value) {
            return andDomainSortIndexLessThanOrEqualTo(Integer.valueOf(value));
        }

        public Criteria andDomainSortIndexLessThanOrEqualTo(
            java.lang.Integer value) {
            addCriterion(ISysRoleDAO.DomainSortIndex + " <=", value,
                "domainSortIndex");

            return this;
        }

        public Criteria andDomainSortIndexLessThanOrEqualToForeignKey(
            java.lang.String key) {
            StringBuffer str = new StringBuffer(ISysRoleDAO.DomainSortIndex);
            str.append(" <= ").append(key);
            addForeignKeyCriterion(str.toString());

            return this;
        }

        public Criteria andDomainSortIndexLessThanOrEqualTo(
            BaseQueryBean subQueryBean, IDataAccessInterface<?, ?> dao) {
            addCriterion(ISysRoleDAO.DomainSortIndex + " <= ", subQueryBean, dao);

            return this;
        }

        public Criteria andDomainSortIndexIn(int[] values) {
            if (values.length == 1) {
                return andDomainSortIndexEqualTo((java.lang.Integer) values[0]);
            } else {
                addCriterion(ISysRoleDAO.DomainSortIndex + " in", values,
                    "domainSortIndex");

                return this;
            }
        }

        public Criteria andDomainSortIndexNotIn(int[] values) {
            if (values.length == 1) {
                return andDomainSortIndexNotEqualTo((java.lang.Integer) values[0]);
            } else {
                addCriterion(ISysRoleDAO.DomainSortIndex + " not in", values,
                    "domainSortIndex");

                return this;
            }
        }

        public Criteria andDomainSortIndexIn(List<java.lang.Integer> values) {
            if (values.size() == 1) {
                return andDomainSortIndexEqualTo(values.get(0));
            } else {
                addCriterion(ISysRoleDAO.DomainSortIndex + " in", values,
                    "domainSortIndex");

                return this;
            }
        }

        public Criteria andDomainSortIndexNotIn(List<java.lang.Integer> values) {
            if (values.size() == 1) {
                return andDomainSortIndexNotEqualTo(values.get(0));
            } else {
                addCriterion(ISysRoleDAO.DomainSortIndex + " not in", values,
                    "domainSortIndex");

                return this;
            }
        }

        public Criteria andDomainSortIndexIn(java.lang.Integer[] values) {
            if (values.length == 1) {
                return andDomainSortIndexEqualTo(values[0]);
            } else {
                addCriterion(ISysRoleDAO.DomainSortIndex + " in",
                    Arrays.asList(values), "domainSortIndex");

                return this;
            }
        }

        public Criteria andDomainSortIndexNotIn(java.lang.Integer[] values) {
            if (values.length == 1) {
                return andDomainSortIndexNotEqualTo(values[0]);
            } else {
                addCriterion(ISysRoleDAO.DomainSortIndex + " not in",
                    Arrays.asList(values), "domainSortIndex");

                return this;
            }
        }

        public Criteria andDomainSortIndexIn(BaseQueryBean subQueryBean,
            IDataAccessInterface<?, ?> dao) {
            addCriterion(ISysRoleDAO.DomainSortIndex + " in ", subQueryBean, dao);

            return this;
        }

        public Criteria andDomainSortIndexNotIn(BaseQueryBean subQueryBean,
            IDataAccessInterface<?, ?> dao) {
            addCriterion(ISysRoleDAO.DomainSortIndex + " not in ",
                subQueryBean, dao);

            return this;
        }

        public Criteria andDomainSortIndexBetween(int value1, int value2) {
            addCriterion(ISysRoleDAO.DomainSortIndex + " between", value1,
                value2, "domainSortIndex");

            return this;
        }

        public Criteria andDomainSortIndexBetween(java.lang.Integer value1,
            java.lang.Integer value2) {
            addCriterion(ISysRoleDAO.DomainSortIndex + " between", value1,
                value2, "domainSortIndex");

            return this;
        }

        public Criteria andDomainSortIndexNotBetween(int value1, int value2) {
            addCriterion(ISysRoleDAO.DomainSortIndex + " not between", value1,
                value2, "domainSortIndex");

            return this;
        }

        public Criteria andDomainSortIndexNotBetween(java.lang.Integer value1,
            java.lang.Integer value2) {
            addCriterion(ISysRoleDAO.DomainSortIndex + " not between", value1,
                value2, "domainSortIndex");

            return this;
        }

        public Criteria andDomainIconIsNull() {
            addCriterion(ISysRoleDAO.DomainIcon + " is null");

            return this;
        }

        public Criteria andDomainIconIsNotNull() {
            addCriterion(ISysRoleDAO.DomainIcon + " is not null");

            return this;
        }

        public Criteria andDomainIconIsNotEmpty() {
            addCriterion(ISysRoleDAO.DomainIcon + " is not null AND " +
                ISysRoleDAO.DomainIcon + " <> ''");

            return this;
        }

        public Criteria andDomainIconIsEmpty() {
            addCriterion("(" + ISysRoleDAO.DomainIcon + " is null OR " +
                ISysRoleDAO.DomainIcon + " = '')");

            return this;
        }

        public Criteria andDomainIconEqualTo(String value) {
            addCriterion(ISysRoleDAO.DomainIcon + " = ", value, "domainIcon");

            return this;
        }

        public Criteria andDomainIconEqualToForeignKey(java.lang.String key) {
            StringBuffer str = new StringBuffer(ISysRoleDAO.DomainIcon);
            str.append(" = ").append(key);
            addForeignKeyCriterion(str.toString());

            return this;
        }

        public Criteria andDomainIconEqualTo(BaseQueryBean subQueryBean,
            IDataAccessInterface<?, ?> dao) {
            addCriterion(ISysRoleDAO.DomainIcon + " = ", subQueryBean, dao);

            return this;
        }

        public Criteria andDomainIconNotEqualTo(String value) {
            addCriterion(ISysRoleDAO.DomainIcon + " <>", value, "domainIcon");

            return this;
        }

        public Criteria andDomainIconNotEqualToOrIsNull(String value) {
            addCriterion(ISysRoleDAO.DomainIcon + " is null OR " +
                ISysRoleDAO.DomainIcon + " <>", value, "domainIcon");

            return this;
        }

        public Criteria andDomainIconNotEqualToForeignKey(java.lang.String key) {
            StringBuffer str = new StringBuffer(ISysRoleDAO.DomainIcon);
            str.append(" <> ").append(key);
            addForeignKeyCriterion(str.toString());

            return this;
        }

        public Criteria andDomainIconNotEqualTo(BaseQueryBean subQueryBean,
            IDataAccessInterface<?, ?> dao) {
            addCriterion(ISysRoleDAO.DomainIcon + " <> ", subQueryBean, dao);

            return this;
        }

        public Criteria andDomainIconGreaterThan(String value) {
            addCriterion(ISysRoleDAO.DomainIcon + " >", value, "domainIcon");

            return this;
        }

        public Criteria andDomainIconGreaterThanForeignKey(java.lang.String key) {
            StringBuffer str = new StringBuffer(ISysRoleDAO.DomainIcon);
            str.append(" > ").append(key);
            addForeignKeyCriterion(str.toString());

            return this;
        }

        public Criteria andDomainIconGreaterThan(BaseQueryBean subQueryBean,
            IDataAccessInterface<?, ?> dao) {
            addCriterion(ISysRoleDAO.DomainIcon + " > ", subQueryBean, dao);

            return this;
        }

        public Criteria andDomainIconGreaterThanOrEqualTo(String value) {
            addCriterion(ISysRoleDAO.DomainIcon + " >=", value, "domainIcon");

            return this;
        }

        public Criteria andDomainIconGreaterThanOrEqualToForeignKey(
            java.lang.String key) {
            StringBuffer str = new StringBuffer(ISysRoleDAO.DomainIcon);
            str.append(" >= ").append(key);
            addForeignKeyCriterion(str.toString());

            return this;
        }

        public Criteria andDomainIconGreaterThanOrEqualTo(
            BaseQueryBean subQueryBean, IDataAccessInterface<?, ?> dao) {
            addCriterion(ISysRoleDAO.DomainIcon + " >= ", subQueryBean, dao);

            return this;
        }

        public Criteria andDomainIconLessThan(String value) {
            addCriterion(ISysRoleDAO.DomainIcon + " <", value, "domainIcon");

            return this;
        }

        public Criteria andDomainIconLessThanForeignKey(java.lang.String key) {
            StringBuffer str = new StringBuffer(ISysRoleDAO.DomainIcon);
            str.append(" < ").append(key);
            addForeignKeyCriterion(str.toString());

            return this;
        }

        public Criteria andDomainIconLessThan(BaseQueryBean subQueryBean,
            IDataAccessInterface<?, ?> dao) {
            addCriterion(ISysRoleDAO.DomainIcon + " < ", subQueryBean, dao);

            return this;
        }

        public Criteria andDomainIconLessThanOrEqualTo(String value) {
            addCriterion(ISysRoleDAO.DomainIcon + " <=", value, "domainIcon");

            return this;
        }

        public Criteria andDomainIconLessThanOrEqualToForeignKey(
            java.lang.String key) {
            StringBuffer str = new StringBuffer(ISysRoleDAO.DomainIcon);
            str.append(" <= ").append(key);
            addForeignKeyCriterion(str.toString());

            return this;
        }

        public Criteria andDomainIconLessThanOrEqualTo(
            BaseQueryBean subQueryBean, IDataAccessInterface<?, ?> dao) {
            addCriterion(ISysRoleDAO.DomainIcon + " <= ", subQueryBean, dao);

            return this;
        }

        public Criteria andDomainIconLike(String value) {
            StringBuffer buffer = new StringBuffer("%");
            buffer.append(value);
            buffer.append("%");
            addCriterion(ISysRoleDAO.DomainIcon + " like", buffer.toString(),
                "domainIcon");

            return this;
        }

        public Criteria andDomainIconNotLike(String value) {
            StringBuffer buffer = new StringBuffer("%");
            buffer.append(value);
            buffer.append("%");
            addCriterion(ISysRoleDAO.DomainIcon + " not like",
                buffer.toString(), "domainIcon");

            return this;
        }

        public Criteria andDomainIconIn(List<String> values) {
            if (values.size() == 1) {
                return andDomainIconEqualTo(values.get(0));
            } else {
                addCriterion(ISysRoleDAO.DomainIcon + " in", values,
                    "domainIcon");

                return this;
            }
        }

        public Criteria andDomainIconNotIn(List<String> values) {
            if (values.size() == 1) {
                return andDomainIconNotEqualTo(values.get(0));
            } else {
                addCriterion(ISysRoleDAO.DomainIcon + " not in", values,
                    "domainIcon");

                return this;
            }
        }

        public Criteria andDomainIconIn(String[] values) {
            if (values.length == 1) {
                return andDomainIconEqualTo(values[0]);
            } else {
                addCriterion(ISysRoleDAO.DomainIcon + " in",
                    Arrays.asList(values), "domainIcon");

                return this;
            }
        }

        public Criteria andDomainIconNotIn(String[] values) {
            if (values.length == 1) {
                return andDomainIconNotEqualTo(values[0]);
            } else {
                addCriterion(ISysRoleDAO.DomainIcon + " not in",
                    Arrays.asList(values), "domainIcon");

                return this;
            }
        }

        public Criteria andDomainIconIn(BaseQueryBean subQueryBean,
            IDataAccessInterface<?, ?> dao) {
            addCriterion(ISysRoleDAO.DomainIcon + " in ", subQueryBean, dao);

            return this;
        }

        public Criteria andDomainIconNotIn(BaseQueryBean subQueryBean,
            IDataAccessInterface<?, ?> dao) {
            addCriterion(ISysRoleDAO.DomainIcon + " not in ", subQueryBean, dao);

            return this;
        }

        public Criteria andDomainIconBetween(String value1, String value2) {
            addCriterion(ISysRoleDAO.DomainIcon + " between", value1, value2,
                "domainIcon");

            return this;
        }

        public Criteria andDomainIconNotBetween(String value1, String value2) {
            addCriterion(ISysRoleDAO.DomainIcon + " not between", value1,
                value2, "domainIcon");

            return this;
        }
    }
}
